I need to be able to select from a list names randomly, how do I do this?
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks