making random sorts in Microsoft Excel (Macintosh)

A

Allannah_Thomas

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

Mike Middleton

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
 
J

JE McGimpsey

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

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

ltkaku

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

Mike Middleton

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
 
P

PhilD

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.
Click to expand...


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