I have to work out and write down (on a spreadsheet):
how many groups of three numbers can be extracted (without repetition) from 80.
as an illustration:
there is only one group of three numbers in 3 (1,2,3)
there are four groups of three numbers in 4 (1,2,3 1,2,4 1,3,4 2,3,4)
there are 10 groups of three numbers in 6 (see attached worksheet)
I hope this calculation makes sense.
I need help with the formula for determining how many combinations, but in addition I also need them written out in a spreadsheet in an ordered way similar to that arranged in the attached worksheet.
I would be very grateful for help
sample-3.xls
Now, what would be great would be a way of listing them all out in order.
1 2 3 (each number to its own cell)
1 2 4
1 2 5
1 2 6.... etc