Forum Discussion
Excel random sort in one column. only 10 to 50 numbers
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.
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))