Selecting a random name (2003)

Topic

New Reply

Is there a way to select a random name from a list?

Reply | Quote

Replies

if your list is in A1:A100
=index(a1:A100,INT(RAND()*100)+1)
will give a random name from the list

Steve

Reply | Quote

Perfect! Thanks

Reply | Quote

Perfect! Thanks

Reply | Quote

Is there a method in Excel to prevent the same name from being selected a second time?

Reply | Quote

Not with a formula, but you can do it with VBA code. The code in the workbook in This Post creates a random list of names for a mailing from a longer list with no repeats. It could be modified to do what you want. The code in This Post creates a list of random integers with no repeats that could be used as indexes to select from your list.

Reply | Quote

Not with a formula, but you can do it with VBA code. The code in the workbook in This Post creates a random list of names for a mailing from a longer list with no repeats. It could be modified to do what you want. The code in This Post creates a list of random integers with no repeats that could be used as indexes to select from your list.

Reply | Quote

Is there a method in Excel to prevent the same name from being selected a second time?

Reply | Quote

Chona

I did a very simple piece of code for a colleague who wanted to do monthly prize draw.

I hope this helps

Reply | Quote

Chona

I did a very simple piece of code for a colleague who wanted to do monthly prize draw.

I hope this helps

Reply | Quote