ExcelBanter - Random name

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Random name (https://www.excelbanter.com/excel-worksheet-functions/105469-random-name.html)

[email protected]

Random name

hello,

Does anyone know the formula for random name selection using one
column?

thanks,

Biff

Random name

One way:

Assume you have 15 names in the range A1:A15.

=INDEX(A1:A15,INT(RAND()*15)+1)

Will return a different name (although repeats are possible) every time a
calculation is triggered. To make a new selection just press F9.

Biff

wrote in message
ps.com...
hello,

Does anyone know the formula for random name selection using one
column?

thanks,

All times are GMT +1. The time now is 07:26 AM.