Select Random From List in Google Sheets
Learn how to randomly select a winner from a list in Google Sheets using the RANDBETWEEN function and other formulas. This tutorial walks you through the process step-by-step, ensuring you can automate your selection without manual counting.
We want to randomly select a name from this list. We have a, in this case, in this use case, we have a lottery and we have some winners or a winner. We want to pick a winner from this list of names, tickets, however much information else you have here. You can have more information. So we're gonna do this with a formula , and I'm going to piece it together step by step and show you the very first formula we're gonna use is ran between.
need the numbers one and two. So we can actually start our list off at number three, and I just want to make sure you know that this is inclusive. So it says here, right in the ballot returns a uniformly random integer between two values inclusive.
Let's say we add one name. Bart Simpson just has another one, and he is A-V-V-I-P. Well, our number up here, 52, has not changed. This is what's called hard coded, or I just wrote it in, I manually wrote in the number , but let's make that automatic.
A three colon A so we don't know the end of it, so we're just gonna put a, we're not gonna put a number there. But an interesting thing happens, and it's gonna be very hard to show you, but count A is not going to count all of the, if there's blanks.
into the exact same place. There we go. Because if we do count a plus count blank here, a three colon A, we're going to always have the correct information.
Victor, here you go. Yes, it is correct. If you want to declare a winner, and you don't want this formula anymore, meaning you don't want it changing, if you're gonna add, say a, anything that changed already, if you're gonna do any more changes to your sheet, you can select these command C or right click copy, and then you can also paste special .
a random item from a list. You are watching better sheets here on YouTube. Make sure you check out this video or this video and subscribe right now to get more tips, tricks, how tos, get more out of your Google sheets than you ever have before.