Google Answers Logo
View Question
 
Q: Need to "shuffle" a column in Excel... ( No Answer,   1 Comment )
Question  
Subject: Need to "shuffle" a column in Excel...
Category: Computers > Software
Asked by: dotw-ga
List Price: $2.00		 Posted: 12 Jul 2005 20:40 PDT
Expires: 11 Aug 2005 20:40 PDT
Question ID: 542875 
How do I randomly shuffle information contained in a column in Excel?
Answer  
There is no answer at this time.

Comments  
Subject: Re: Need to "shuffle" a column in Excel...
From: leskowitz-ga on 12 Jul 2005 22:19 PDT		  
If your data was in colomn A, one way would be to go over to colomn B
and type =rand() and then highlight both columns and sort on colomn B.
 It will work, kind of slopply though.
Important Disclaimer: Answers and comments provided on Google Answers are general information, and are not intended to substitute for informed professional medical, psychiatric, psychological, tax, legal, investment, accounting, or other professional advice. Google does not endorse, and expressly disclaims liability for any product, manufacturer, distributor, service or service provider mentioned or any opinion expressed in answers or comments. Please read carefully the Google Answers Terms of Service.

If you feel that you have found inappropriate content, please let us know by emailing us at answers-support@google.com with the question ID listed above. Thank you.
Search Google Answers for
Google Answers  

Google Home - Answers FAQ - Terms of Service - Privacy Policy