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.
I felt sorry for Excel 2019 users in that they missed the cut and didn't get the new dynamic arrays. Perhaps there should be a trade-in offer to move to Excel 2021 or 365?
= SORTBY(
SEQUENCE(52),
RANDARRAY(52)
)
is neat and self contained. Prior to that, a helper range is needed, so that the random numbers can be ranked without the values changing throughout the calculation
"helper column, 'random'"
= RAND()
"Formula column, array or implicit intersection"
= RANK(random, random)