Hi guys, this is possibly something that has been addressed before, but I'm struggling to find something to help me out. Basically I have a few horse selections from each race, and I want to get all the possible combinations.
Example.
RACE 1 - Horse 7, Horse 12
RACE 2 - Horse 1, Horse 4
RACE 3 - Horse 8, Horse 11
RACE 4 - Horse 1, Horse 2
RACE 5 - Horse 3, Horse 16
RACE 6 - Horse 2
RACE 7 - Horse 5, Horse 10
RACE 8 - Horse 9, Horse 6
Only one horse can be used from each race. Sometimes there are more than 2 choices of horses so being able to add another horse or take one off, or even only having one horse, is needed for each race. Sometimes there are also more than 8 races, generally up to 12. Being able to add in races/horses is needed without giving a False readout.
The combinations should display up to be easily printed out, from the example given there's probably about 30 or so combinations, so displayed will be easy enough to mark off as you go through every combination.
I haven't touched any coding or much excel formula for a very long time, so if I'm not familiar with much, just bare with me, I can generally pick it up fairly quickly.
Thanks in advance for anyone that can help me with this.