Horse racing treble permutations

[mazdaq100]

Let's say I've selected 10 horses to bet on during a day and I would like to combine them into trebles covering all different permutations. There is more than 1 horse in each race that I want to bet on. For example,

Race 1: Horses 6 & 9
Race 2: Horses 2, 4 & 7
Race 3: Horses 1, 3, 5 & 8

I know that there are 24 different treble permutations. Is there any way to put the horse numbers into excel and then excel will display all 24 different permutations?

Thanks.

 

[Gerald Higgins]

Can you tell us what the results should be in your example ?

 

[mazdaq100]

Sure, the 24 different permutations are:

6,2,1
6,2,3
6,2,5
6,2,8
6,4,1
6,4,3
6,4,5
6,4,8
6,7,1
6,7,3
6,7,5
6,7,8
9,2,1
9,2,3
9,2,5
9,2,8
9,4,1
9,4,3
9,4,5
9,4,8
9,7,1
9,7,3
9,7,5
9,7,8

 

[mazdaq100]

I guess one way would be to simply set up a formula for each of the 24 permutations, just referring back to each cell that the horses number is in.

However, I was wondering if there was a more streamlined way.