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.
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.
- Thank you so much, I was very tired last time i tried it, did not even see it. Thank you so much for the help, I appreciate it, and thanks to everyone that was willing to help. I will defnitely come back if I have blonde moments again 🙂
- Thank you, will check it out now.
Just noticed that i had
x = Int(Rnd * 50 + 1)
instead of
x = Int(Rnd * 52 + 1)
Attached please find the adapted file for randbetween 1-52.
- This partially works, how can I make it use number from 1-52 and still have 52 cells, like all numbers must be shown everytime and when I click it it must give me random values but still 52 cells. Every number must be shown from 1-52 everytime I recalculate?