RAND function returns repeat numbers

E

emmsee

Joined
Apr 12, 2007
Messages
4
Reaction score
0
How can I ensure that a RAND function in my spreadsheet does not return the same number more than once?

This is my formula: =RANDBETWEEN(1,153)

Each time I press f9 a new number appears however after some time the same number will reappear.

thanks
emmsee
 

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

Excel Repeating a RAND() function under certain conditions 0
What does Excel's RAND function really do 0
What does Excel's RAND function really do 4
Adding Random Numbers 22
How to get repeatable Excel RAND sequence? 12
I want random numbers generated without repeating numbers 4
generate a random number and use if function to generate new data 4
same number appears in a random number generator 4

Back
Top