Select from a list

[frisbee_train]

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]

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

 

[Teethless mama]

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