View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Sumeet Benawra Sumeet Benawra is offline
external usenet poster
 
Posts: 1
Default Need to generate random values from a list

Hi

I want to be able to create a random values from a given list of values.

e.g. In column A, there are these values:
aaaa
bbbb
cccc
dddd
eeee
ffff

In another column, I want to randomly populate each cell with a value from
column A.

How can I do this?

Thanks