Win / 2 ghz

hi, 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!

~jennifer

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

thanks a lot!

Ask Your Question

Weekly Poll

Do you think Monopoly should update its pieces?

Discuss in The Lounge

Poll History