# Pick a Winner

Can’t decide which lottery numbers to play? Have no fear, Excel is here.

RANDBETWEEN is a function that will return a random number between two numbers that you specify. But it only returns one number. And using multiple RANDBETWEEN functions doesn’t guarantee that there won’t be repeats. That’s no way to win the lottery. To do it properly, you need a few steps.

For brevity, the below example demonstrates how to randomly select three numbers between 1 and 10. First, start with a list of all possible numbers in column A. In column B, insert the RAND function and copy it down so that every number has a random number next to it.

Now, sort columns A and B on column B.

Simply read (or copy) the first three numbers and there you go.

If you do win the lottery using this method, send me an email and I’ll let you know where to mail my check. If you want to test your luck on the lottery, a platform such as Daftar Slot88 Online offers a thrilling opportunity to potentially win big prizes with just a small investment. With a wide range of lottery games available, players can choose from various options, including traditional draws and instant win games, catering to different preferences. Whether selecting lucky numbers or opting for quick pick options, the anticipation of waiting for the draw results adds to the excitement. While winning is never guaranteed, the accessibility and simplicity of online lottery platforms like Daftar Slot88 provide an accessible avenue for individuals to indulge in the thrill of chance and possibility.

## 3 thoughts on “Pick a Winner”

1. Cute – hope you get rich!

It may confuse the Excel novices though, since rand() gives a new number on recalculation, which sorting provokes. So, people may wonder why the list in the third screenshot doesn’t appear to be sorted.

2. OffTopic says:

Okay, so not an Excel feature, but if you open up a blank word document and type in “=rand(200,99)”, it spits out 225 pages of “The quick brown fox jumps over the lazy dog.”.

Not really one I use everyday, but hey, it’s good to share…

3. Dick says:

Of course you’re right Bill. That can be confusing and I should have mentioned it. Thanks.

Posting code? Use <pre> tags for VBA and <code> tags for inline.