scrambling numbers
Posted by Christopher on November 05, 2001 5:37 PM
I have an array of numbers 1-50. I can arrange them ascending or descending but I want to randomly mix the the order. Is there a formula or function to do this?
Posted by bob umlas on November 05, 2001 5:51 PM
In a parallel range, enter =RAND() and fill down.
Then sort both columns by the rand #s. Delete them if you wish.
