View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Engineering Accountant
 
Posts: n/a
Default How can I make the rows go into a random order?

Add a Column in you data set with the function =Rand().

Then you can sort by that column.


"chicken99" wrote:

I am doing some statistical work, and I am trying to use a systematic sample,
but the rows of data need to be random. How can I make excel do this?