Random list (1-45) without repeating numbers?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

RANDBETWEEN() 9
Excel 2003: random (1 to 24) to get 24 results without repeat? 4
Using =RANDBETWEEN(a,b) in a paers of a whole colume 1
How can I use the same random number twice in the same formula? 2
Can I randomise the order of a number of rows? 6
RANDBETWEEN generating numbers outside range 5
random number generator 6
random letter generation 5

Back
Top