ExcelBanter - I want Excel to randomly select a name from a list

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

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

- - I want Excel to randomly select a name from a list (https://www.excelbanter.com/excel-worksheet-functions/110729-i-want-excel-randomly-select-name-list.html)

[email protected]

I want Excel to randomly select a name from a list

--
brightstar

Biff

I want Excel to randomly select a name from a list

One way:

Names in the range A1:A10.

=INDEX(A1:A10,INT(RAND()*ROWS(A1:A10)+1))

A new name will be returned every time a calculation occurs. If you want to
force an new selection press function key F9.

Biff

" wrote in
message ...

--
brightstar

All times are GMT +1. The time now is 02:58 PM.