Excel random formula

Win / 2 ghz
January 16, 2009 at 07:58:42
Specs: Windows XP, 4

i am trying to use excel to randomize specific jobs for some students. in the first column lists the jobs then i need to randomize the students (or vice versa).

any help would be greatly appreciated!


See More: Excel random formula

Report •

January 18, 2009 at 13:35:43
Use the RAND() function.

List Jobs in column A,
List Names in column B
and the =RAND() function in column C.
then select columns B & C
then Sort columns B & C on column C
and you should get what your looking for.


Report •

January 20, 2009 at 11:22:15
thanks a lot!

Report •

Related Solutions

Ask Question