G Guest Oct 18, 2007 #1 I have a list of about 60 names that I need to randomly compile every day. Does excel have a function for this?
I have a list of about 60 names that I need to randomly compile every day. Does excel have a function for this?
D David Biddulph Oct 18, 2007 #2 Put =RAND() in an adjacent column. Select the range including both column, and sort by the random number. Sort again as often as you like, as the RAND() will recalculate each time.
Put =RAND() in an adjacent column. Select the range including both column, and sort by the random number. Sort again as often as you like, as the RAND() will recalculate each time.
