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.
3 Replies
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))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.
- Thanks so much. I eventually used the RAND function and that sorts it out fine. Took me a while to work out how to use it!!
Thanks,
Chris
