Forum Discussion
HELP!! Combinations have me so confused
So I found a website last year that did all this for me when I was trying to do it, but I cannot for the life of me remember what I googled to find this so I am starting from scratch because every th...
I realize this discussion pre-dates the advent of dynamic arrays and the OP is long gone.
The expected 2 4 7 pairings seems to be the math for 23 people total (Subtracting the pairs where A is B, e.g. Andrew and Andrew). I believe the OP meant to find all pairs for 22 people which would be:
=Combinationsλ(all,2)I had some fun with this and added in a 3rd and 4th list.
Note: The 3 digit integer is listed with spaces because if it doesn't include spaces it trips a specific forum filter.