How to Select a Random Row in Excel or Google Sheets (No VBA Needed)

📬 Get good at automations: https://www.gotsheet.xyz/c/gotsheet-youtube Want to randomly select a row in Excel or Google Sheets? This tutorial walks you through the exact formulas you need using RANDBETWEEN, INDEX, ROWS, and FILTER—no VBA or coding required. Whether you’re picking a winner, pulling sample data, or just want a simple spreadsheet trick, this solution works beautifully. 🤯 In this video, you'll learn: How to set up a dynamic random row generator Why RANDBETWEEN refreshes on every change How to use LET for cleaner formulas Cross-platform tricks that work in both Excel and Google Sheets 📌Get 20% off your first 3 months of beehiiv - https://www.beehiiv.com/partners/got-sheet?via=eamonn 👉 Subscribe for weekly AI tools, creative hacks, and automation strategies 🎥 Watch next: https://youtu.be/Kn7W4DL8W8Q 🛠️ Tools I used: https://www.gotsheet.xyz/c/business-tech-stack 📅 Book 1 on 1 consulting with me - https://cal.com/eamonncottrell _______________________________________________ 📲 Find me https://eamonncottrell.com on LinkedIn: https://www.linkedin.com/in/eamonncottrell/ on Twitter: https://twitter.com/EamonnCottrell _______________________________________________ 📍Chapter Time Markers: 00:00 - intro 00:09 - overview 00:40 - full formula 00:58 - RANDBETWEEN 01:58 - ROWS 02:12 - INDEX 03:19 - ROW 04:12 - FILTER 05:28 - LET