 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / June 2004Randomize a column of words in Excel?
I am a relatively basic and new Excel user...I'm not very schooled in Macro-building or running or what have you! I've been given the task of randomizing a list of words. They are currently in one long column in Excel... Is there any way to do this without a Macro? And if not...can anyone calmly help me through the process? ANY HELP WOULD BE HELP OF THE HIGHEST REGARD! Thanks again. Peace and good vibes to you all. One way to do this, without VBA, would be to enter =RAND() in a column adjacent to your word list, copying down as far as you need to go. Then, sort the worksheet using the RAND column as the sort key.  SignatureCordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com > I am a relatively basic and new Excel user...I'm not very schooled in Macro-building or running or what have you! > [quoted text clipped - 3 lines] > > ANY HELP WOULD BE HELP OF THE HIGHEST REGARD! Thanks again. Peace and good vibes to you all. |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.