ExcelBanter - Select from a list

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

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

- - Select from a list (https://www.excelbanter.com/excel-worksheet-functions/178973-select-list.html)

frisbee_train

Select from a list

does anyone know how to get excel to select randomly from a list of values.

lets say A1=Dave, A2=Gaz, A3= James, A4=pete.

is there are function that can select one of the four names randomly?

Mike H

Select from a list

One way with your list in column A try this formula in another cell

=INDIRECT("A"&RANDBETWEEN(1,4))

Change the 4 to however many names you have in your list and Tap F9 to get a
different name.

Mike

"frisbee_train" wrote:

does anyone know how to get excel to select randomly from a list of values.

lets say A1=Dave, A2=Gaz, A3= James, A4=pete.

is there are function that can select one of the four names randomly?

Teethless mama

Select from a list

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

"frisbee_train" wrote:

does anyone know how to get excel to select randomly from a list of values.

lets say A1=Dave, A2=Gaz, A3= James, A4=pete.

is there are function that can select one of the four names randomly?

All times are GMT +1. The time now is 05:01 PM.