select names randomly

I need to be able to select from a list names randomly, how do I do this?

Assuming that the names are in Col A starting at A1, use this formula.

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

this will change each time an action occurs on that workbook.

if your list of names start at Row 3 in Col C, for example, than your formula will change to this

=INDEX(C:C,RANDBETWEEN(3,2 + COUNTA(C:C)))

Cheers!

Note: This also assumes that only names exists in the column