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?

 

[FunkyT]

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