list names in random order in Excel 2002
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 |
list names in random order in Excel 2002
"John Murf" wrote
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 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
list names in random order in Excel 2002
Replied to OP:
----------------------- Glad it helped, John ! --- john Murphy wrote: Hi Max, Thanks for the pointer to listing the names in random order, it works a treat. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
All times are GMT +1. The time now is 09:45 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com