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.

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.

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.

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.

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.