making random sorts in Microsoft Excel (Macintosh)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Allannah_Thomas@officeformac.com - 20 Jan 2008 18:06 GMT

Can someone tell me the name of software that will enable me to sort data randomly in Microsoft Excel (Macintosh)? Thanks

Reply to this Message

Mike Middleton - 20 Jan 2008 18:18 GMT

Allannah_Thomas -

One way is to enter =RAND() in an adjacent helper column and sort using the
random numbers as the key.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

Can someone tell me the name of software that will enable me to sort data
randomly in Microsoft Excel (Macintosh)? Thanks

Reply to this Message

JE McGimpsey - 20 Jan 2008 21:33 GMT

> Can someone tell me the name of software that will enable me to sort data
> randomly in Microsoft Excel (Macintosh)? Thanks

Excel would be one...

The easiest way is to, in an adjacent column, enter

=RAND()

and copy down as far as your data goes. Sort on that column.

Reply to this Message

ltkaku - 13 Mar 2008 07:23 GMT

Is there a way of randomly assigning number 1 or 2 for a total of 60 students so 30 would be 1 and 30 would be 2.

Reply to this Message

Mike Middleton - 13 Mar 2008 07:59 GMT

ltkaku -

One way is to enter =RAND() in an adjacent helper column, select the data in
all columns, and sort (Data | Sort ...) using the random numbers as the key.

Then assign 1 to the top 30 students and 2 to the other 30.

- Mike Middleton
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel

> Is there a way of randomly assigning number 1 or 2 for a total of 60
> students so 30 would be 1 and 30 would be 2.

Reply to this Message

PhilD - 13 Mar 2008 09:30 GMT

> One way is to enter =RAND() in an adjacent helper column, select the data in
> all columns, and sort (Data | Sort ...) using the random numbers as the key.
>
> Then assign 1 to the top 30 students and 2 to the other 30.

... and if you don't like the random results, just sort again. The
random number is recalculated each time so you don't need to enter the
formula again.

PhilD

--
<><

Reply to this Message

Mac Forum / Applications / Excel / March 2008

making random sorts in Microsoft Excel (Macintosh)