Hi, not sure if possible but will request here just incase someone can help.
Is it possible to make an excel file that can automatically find all possible combinations from say 4 numbers.
To explain fully, this has to do with horse racing. In one race possible of 24 runners and one venue possible of 10 races.
I am only interested in running this exercise to show possible combination with 4 selections per race.
Example
Venue1
Race 1 - 4,3,2,1
Race 2 - 3,5,6,1
Race 3 - 5,4,2,1
Race 4 - 6,7,9,10
Race 5 - 2,3,1,4
Okay can the excel show all combination of all these selections?
Thank you for your attention, and hopefully you can help.
Bookmarks