MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Randbetween function


Posted by Paul on September 04, 2001 12:21 PM

Is there a way to use the RANDBETWEEN function on different cell A1:D10, so you want get duplicate numbers? thanks. excel'97


Posted by Mark W. on September 04, 2001 1:54 PM

If you need 40 random, non-repeating values try this...

Enter =RAND() into cells A1:D10. Next, enter
=RANK(A1,$A$1:$D$10) into cell A12, Fill right to
cell D12 and Fill down to row 21. Now you have
1 thru 40 randomly selected. You could have
repeats using this method, but the odds are quite
low.

Posted by Adrian on October 16, 2001 12:02 PM

I searched the net for this answer.. thank you so much it worked flawlessly.. no repeats at all. Thanks!

This is what I ended up doing:
I needed something to random 16 numbers for seeding purposes in a tournament. I entered =RAND() into A1:A16. Then put =RANK(A1:$A$1:$A$16) into B1 and copied B1 into B2:B16.