Question: how to work out all possible combinations excel?
Answer: Summary. The Excel COMBIN function returns the number of combinations (in any order) of a given number of items. ... 
Get total number of combinations.
Total possible combinations as an integer.
=COMBIN (number, number_chosen)
number - The total number of items. ... 
A combination is any a group of items in any order.