Forum Discussion
Solved
=RANDBETWEEN NO DUPLICATES BETWEEN 1-52
Hi, I have been struggling with this for some time, I have office 2019, and I want to use that formula as stated in Subject to get a row of random numbers everytime, but the number may have no du...
In the attached file in cell A1 you can enter the number of random numbers which will be displayed in range A3:A54. Click the button in cell D2 to start the macro. Maybe this is what you want to do.
How many random numbers do you want?
1-52
A low-tech approach that works in all versions of Excel:
Enter the numbers 1 and 2 in A1 and A2.
Select A1:A2, then fill down to A52.
In B1, enter the formula =RAND()
Fill down to B52.
Click in B1, then sort ascending.
The numbers in A1:A52 are now in random order.
- Thank you for your reply, If i use RAND then i get values of 0.1555 or 0.8555, I can use =INT to round it to closest number, But this way I will still sit with duplicates, everytime i click on anything it must still recalculate and give me random number, no 0.1888 numbers and then also no duplicates.
I used this one now, it stil give me duplicates though.
=INT(RAND()*52) - You're right! i was thinking he is using office 365,
By the way, i also like your method! absolutely i love your own method
I learnt something new today courtesy of you
