View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
frisbee_train frisbee_train is offline
external usenet poster
 
Posts: 1
Default 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?