Random Numbers

G

Guest

I would like to create 30 random numbers in cells A1 to A30 that are between
1 and 2000, and I do not want duplicates. For example, I don't want cells A5
and A22 to return 1752.
 

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

'Flash' random numbers 6
Questions about copying a Formula 9
Excel Repeating a RAND() function under certain conditions 0
RANDBETWEEN generating numbers outside range 5
Question about an equation 4
Spread numbers by setting up a Min and Max 2
How to make random numbers stay the same 4
RANDBETWEEN() 9

Top