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.
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
