Select Random From List in Google Sheets

Google Sheets: Pick a Random Winner From a List (INDEX + RANDBETWEEN + COUNTA) This episode shows how to randomly select a winner from a list in Google Sheets using formulas. It starts with RANDBETWEEN and explains low/high values, inclusive results, and how the random number recalculates whenever the sheet is edited. It then replaces a hard-coded list length by combining INDEX with an automatically calculated last row using COUNTA, and demonstrates how blanks can cause counting issues, including an optional fix using COUNTA + COUNTBLANK and an alternative recommendation to sort the sheet instead. It also shows how to return additional winner details like a ticket number using INDEX with MATCH, and how to lock a chosen winner by copying and Paste special → values only so the result stops changing. 00:00 Pick a Random Winner 00:17 RANDBETWEEN Basics 01:31 Auto Range with COUNTA 02:29 Handling Blanks in Lists 04:13 Get Ticket Number Too 04:43 Lock the Winner Result 05:24 Wrap Up and Next Videos