New Excel Forum

This forum has been moved to TeachExcel.com

Ask all future questions in the New Excel Forum.

ExcelKey

Horse racing Multi Combinations

Formulas, Functions, Formatting, Charts, Data Analysis, etc.

Horse racing Multi Combinations

Postby vanda » Mon Feb 29, 2016 1:35 am

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. :D
  • 0

vanda
Rookie
 
Posts: 1
Joined: Feb 29, 2016
Reputation: 0
Excel Version: 2013

Return to General Excel Questions

Who is online

Users browsing this forum: No registered users and 118 guests