View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gary''s Student Gary''s Student is offline
external usenet poster
 
Posts: 11,058
Default 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.