Tag Archives: drawing

How to do a Random Drawing / pick at random using Excel

Are you running a contest or sweepstakes an need a system to pick random winners out of a pool of names? You could take the old-school approach of writing names on business cards and pulling them out of a fishbowl, or you could use Microsoft Excel. Put the names in an excel sheet. add a column and put =RAND() in it. it will give a random number that is recalculated every time a change is made on the sheet. choose that column and click sort “a-z” (or z-a). it won’t matter because each time you do it will randomize the names. Just pick the top one (or top 10) after sorting it.

Posted in Random, Security, Tech Tips | Tagged , , , , , , , | 1 Comment