If you’ve ever tried to run a random office pool, or wanted to do a random giveaway for your website’s visitors, you’ve probably wondered the best way to randomly pick from a group of people.

The Productivity Portfolio runs down a quick way to generate a random number in Excel, combined with sorting a list to figure out a random item from the list. Hit the link for the full explanation. 

Use Excel RANDBETWEEN to Select List Names – Productivity Portfolio