Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I need to create a large number of randomly sorted lists from a single master list (random team order per event based on a list of teams entered for all events). Some of the entries must remain in the same order in each list, but the remaining entries must be shuffled.
ie. Teams are A, B, C, D, E, F, G, H, J, K and L . CD and HJK must always appear in the same order. Therefore B.CD.ME.HJK.FAGL, AF.HJK.GMLEB.CD, HJK.FL.CD.EBAGM etc are all valid solutions. I can create a fully random list easily, but can't find an easy way to keep the important entries in the same order. Cheers Waz. Submitted via EggHeadCafe - Software Developer Portal of Choice Look Ma, No DataBase! Bamboo Prevalence http://www.eggheadcafe.com/tutorials...abase-bam.aspx |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to applying a ratio (whilst keeping total the same!) | Excel Worksheet Functions | |||
Concatenate whilst keeping formatting | Excel Discussion (Misc queries) | |||
how to identify unique list of 200 random entries from a list of 3 | Excel Worksheet Functions | |||
Keeping Chart Series Formats whilst sorting | Charts and Charting in Excel | |||
Right Filling A Formula Whilst Keeping A Static Column | Excel Discussion (Misc queries) |