Excel Magic Trick 1092


See how to build an array formula that uses the COUNTIF & SUMPRODUCT functions as well as a function argument array operation, a comparative array operation and a math array operation in a single cell formula to Count Double, Triple, Quadruple, Quintuple Occurrences of numbers in a column.