Excel Magic Trick 1092

DESCRIPTION

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.

WORKBOOKS