Prize draw random names from a list in Excel?

[FunkyT]

I've got a list of names in Excel and would like to randomly draw one. Is there a function which could do this? Perhaps I'd be better off using a seperate, dedicated app?

 

[|Ric|]

I don't think you will get a satisfactory solution from a function because any randomly generated value changes everytime a cell somewhere changes.
Potentially you could just generate a random number in the range of the cells with names in and use that to retrive the value in the i th cell where i = random number.

Depending how you want it to function exactly it would be best probably to create a macro and add a button. Everytime the button is pressed generate a random number and then return the value in that cell. This then only changes when you press the button.

 

[FunkyT]

Thanks for the helpful reply. In the end I opted for the "manual tombola" approach