Different Combinations of 24 Numbers

I am producing some trifecta sweep tickets for an upcoming horse race.

This means i need to take the numbers, 1 through to 24 and put them into groups of three in every possible variation. A total of 2,024 combinations.

For example

1,6,12
2,8,24
etc

I'm hoping there is some way that excel can put all of the variations together for me, even if they are in adjoining cells.

Thank you, worked perfectly.

Looks like I spoke to soon.


The solution provided isn't quite what I need. I need to take 24 numbers, 1 to 24, and generate every possible combination.

The solution provided gave me every possible permutation. For example the solution gave me 1,2,3 & 2,3,1 & 3,2,1 etc etc. But for my purposes 1,2,3 is the same as 2,1,3 because it is the unique combinations I need, order does not matter

Hi


This code will list all permutations.

If I wish to input the PRICE of each runner - eg. Runner A 2.50 Runner B 5.50 Runner C 8.00 etc.........

And I wish to use calculation A.(AB-1).(C+1)/A +1 to value the permutation - how could I code this?


Regards