PC Review


Reply
Thread Tools Rate Thread

Can I do a "random order" sort?

 
 
In a Pickle
Guest
Posts: n/a
 
      24th Jun 2008
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.
 
Reply With Quote
 
 
 
 
Gary''s Student
Guest
Posts: n/a
 
      24th Jun 2008
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.

 
Reply With Quote
 
Bob I
Guest
Posts: n/a
 
      24th Jun 2008
In a helper column put =RAND() and then sort on that column.

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.


 
Reply With Quote
 
Tom Hutchins
Guest
Posts: n/a
 
      24th Jun 2008
In the first free column, enter =RAND() in the first row, then copy down
through all rows of data. Sort by this column to randomize your data.

Hope this helps,

Hutch

"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.

 
Reply With Quote
 
Gord Dibben
Guest
Posts: n/a
 
      24th Jun 2008
In an adjacent column enter =RAND() then double-click to copy down.

Select all columns and sort on that column.


Gord Dibben MS Excel MVP

On Tue, 24 Jun 2008 12:16:01 -0700, In a Pickle <In a
(E-Mail Removed)> 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.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Sort order messed up in "open" and "save as" dialog boxes =?ISO-8859-1?Q?Jos=E9_Sanchez?= Windows XP General 0 23rd Nov 2006 11:35 AM
Sort order messed up in "open" and "save as" dialog boxes =?ISO-8859-1?Q?Jos=E9_Sanchez?= Windows XP Help 0 23rd Nov 2006 11:35 AM
Sort order for "Open"/"Save" Dialog Boxes rich@bittar.org Windows XP Customization 2 15th May 2006 10:14 PM
REQ: file name randomiser or "sort by random" sha Freeware 12 8th Sep 2005 06:46 PM
Show Outlook "Reminders" in chronological order instead of random. =?Utf-8?B?V2VhdGhlcmhlbG0=?= Microsoft Outlook Calendar 0 4th Jan 2005 12:27 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 03:03 PM.