I'm running a fantasy formula 1 game and i want to find out what the best possible team is. Rules are you need to pick 6 drivers from a possible 22. Is there a way of getting excel to list out all the possible combinations. I could then calculate the points for each of those teams. Doesn't feel that efficient but it would work.
Thanks in advance for any tips or advice.
Neal