Randomly select names from a data base in excel

Not sure what you need by spin wheel type of chart, but if you have, say, a header in cell A1 and then the list of names in column A, you could use this formula to randomly draw a winner:

=INDEX(A:A,RANDBETWEEN(2,COUNTA(A:A)-1))

Every time you re-calculate (press F9) you would get a new random name.

If, however, you want to prevent somebody winning two door prizes, you could use a column of formulas to effectively remove their names from the list so that they don't get re-chosen, or randomly sort the names first prior to removing duplicates, or us a macro....  lots of options.

Anything is possible in Excel! 

Well, not ANYthing, but a lot of things ;)

Here's a file to use - fill out the list of names (with repeats as needed to increase the odds) on sheet "Record", then click the "Click me button"  When you're done, erase the names from column A of "Drawing"  If you have trouble figuring out how to use it, let me know.

https://1drv.ms/x/s!AsKdy7Nfg\_Fbgj2pVzR8oKLIpTiT

That is somewhat helpful. What I actually want to do is have 1 sheet with all the names on and use another sheet to randomly select off the first sheet. I would like to display this with a projector so my crowd can see who was drawn. I would like to be able to click a "draw" button and have a random name popup for everyone to see. It would also be nice to have the name removed from the list when it is drawn. I'm not sure if I'm just dreaming or if something like this is actually possible in Excel.

Hi Weaverd131,

Have you referred to the above suggestions? Can you share any update?

Regards,

Jiaxing