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?

See

http://www.mcgimpsey.com/excel/randint.html

In article ,
"Hayes" wrote:

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?