2
In my excel spreadsheet, I am trying to randomly sort a large list. I am doing this by adding in a new column to my table. This table is assigned a random integer between 1 and 10. This is done by =FLOOR(10 * RAND(), 1). Then I want to sort this list of numbers from smallest to largest.
All of this is working except the sorting. When I try to sort it, excel changes the order of the numbers slightly, but it is not from smallest to largest.
Any ideas on how to fix this?
Thanks!
eclaire211
Posted 2015-06-09T18:12:39.577
Reputation: 23
The rand() function recalculates itself. You need to copy and paste values, then sort. – Raystafarian – 2015-06-09T18:15:44.817
If you're getting your data sorted based on the first set of random numbers, isn't that good enough? Do you need to maintain a record of the random values that were the basis for the sort? – Scott – 2015-06-10T04:14:09.613