how to calculate combinations of numbers in excel?
Excel COMBIN Function. The Excel COMBIN function returns the number of combinations (in any order) of a given number of items. To use COMBIN, specify the total number of items and the number of items in each combination.