What is the function to randomly select a cell, like for lottery?

[ap@rfr]

Using Excel, I have a list of names and I need to randomly select one at a
time. How do I create the function to do this?

 

[Teethless mama]

copy the formula to any where you want except in column A