G Guest Feb 24, 2006 #1 I have lists of names that need to be arranged in random order. Also the list should only re-arange on <F9> and not on <enter>
I have lists of names that need to be arranged in random order. Also the list should only re-arange on <F9> and not on <enter>
M Max Feb 24, 2006 #2 I have lists of names that need to be arranged in random order. Also the list should only re-arange on <F9> and not on <enter> Click to expand... One way .. Assume names listed in A1:A10 Put in B1: =INDEX(A:A,RANK(C1,$C$1:$C$10)) Put in C1: =RAND() Select B1:C1, fill down to C10 B1:B10 returns a random shuffle of the names in col A Press F9 to re-generate ---
I have lists of names that need to be arranged in random order. Also the list should only re-arange on <F9> and not on <enter> Click to expand... One way .. Assume names listed in A1:A10 Put in B1: =INDEX(A:A,RANK(C1,$C$1:$C$10)) Put in C1: =RAND() Select B1:C1, fill down to C10 B1:B10 returns a random shuffle of the names in col A Press F9 to re-generate ---
M Max Feb 25, 2006 #3 Replied to OP: ----------------------- Glad it helped, John ! --- john Murphy said: Hi Max, Thanks for the pointer to listing the names in random order, it works a treat. Click to expand... ---
Replied to OP: ----------------------- Glad it helped, John ! --- john Murphy said: Hi Max, Thanks for the pointer to listing the names in random order, it works a treat. Click to expand... ---
