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.

Excel: Pick a Random Winner

Related Posts:

This entry was posted in Random, Security, Tech Tips and tagged , , , , , , , . Bookmark the permalink.

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

  1. Pingback: How to do a Random Drawing / pick at random using Excel | Tech … | Excel Needs

Leave a Reply

Your email address will not be published. Required fields are marked *