Feb 27 2022 01:35 AM
Hi there,
Trying randomly sort numbers in a column from 1 to 50 with no duplicates. I've tried RANDOMARRAY but that returns a random number for each cell and there are duplicates.
Feb 27 2022 01:45 AM
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.
Feb 27 2022 01:58 AM - edited Feb 27 2022 02:01 AM
@Chris144 As a variant, the following formula will create a randomly sorted list of numbers from 1 to 50 without duplication.
=SORTBY(SEQUENCE(50),RANDARRAY(50))
Feb 27 2022 01:58 AM