Can I do a "random order" sort?
Say your data is in A1 thru A100. In B1 enter:
=RAND() and copy down to B100.
Then sort cols A&B by B. This will "shuffle the cards"
--
Gary''s Student - gsnu200793
"In a Pickle" wrote:
Can I do a "random order" sort? Not alpha or numeric. I need to mix up a set
of rows that are now in alpha order. Thanks for any help.
|