Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'd like to create a process that would allow the user to pair up every
possible combination of two items in an array and make a comparison of the two (let's just say they pick the one they like better. I assume I could use nested For-Next loops to do the work something but I'd like input on three things: 1) Avoid repeating combinations, for instance: Compare A to B and later B to A 2) Avoid comparisons to self: Compare A to A 3) Randomize comparisons. If using For-Next, it would first compare A to all other options, then B to all other, then C, etc. How could I skip around but be sure that All possible combinations are asked but not repeated? Thanks for the advice. - John |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
t-test for paired means | Charts and Charting in Excel | |||
Randomized Functions | Excel Discussion (Misc queries) | |||
paired bar chart | Excel Discussion (Misc queries) | |||
Haw to Randomized available data | Excel Worksheet Functions | |||
Populating a select group of cells with randomized names... | Excel Programming |