Friday, October 29, 2004

Count the number of Unique Items in a Range

The following formulas are Array formulas. That means you need to press CTRL SHIFT ENTER when editing or entering the cell.

Use this formula to count the number of unique number items in a range.
=SUM(IF(FREQUENCY(A1:A10,A1:A10)>0,1))

Use this one to incoporate Text into the lookup.
=SUM(IF(FREQUENCY(MATCH(A1:A10,A1:A10,0),MATCH(A1:A10,A1:A10,0))>0,1))