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?


  • The rand() function recalculates itself. You need to copy and paste values, then sort. Commented Jun 9, 2015 at 18:15
  • 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? Commented Jun 10, 2015 at 4:14

1 Answer 1


Your rows are sorted by the previous values of =RAND().

After sorting, the =RAND() function is called again.

Turn off Automatic Calculation from Formulas (ribbon), Calculation Options, Manual.


You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .