View Single Post
  #1   Report Post  
Hayes
 
Posts: n/a
Default Random list (1-45) without repeating numbers?

I'm using Excel 2003. I'm trying to randomize the order of a list of items.
Unfortunately, the only way I've found to do that is to go through item by
item and generate a random number for each, checking manually to insure that
there are no repeats. There has to be a better way. Randbetween didn't help
either, as it also does not weed out repeats. Any way to do this?