formula for sorting data in MS EXCEL
Answers
Answered by
2
Answer:
In the formula row, enter =RAND(). Press Enter. We copy the formula to the whole column - we get a set of random numbers. Now sort the resulting column in ascending / descending order - the values in the original range will automatically be placed in random order.
Similar questions