Formula to find how many unique values in a given range
=SUM(1/COUNTIF(C3:C19,C3:C19))
enter as array formula with CSE
Hi ,
Enter the following , as an array formula , using CTRL SHIFT ENTER , in D3 and copy down.
=SUM(1/COUNTIF($C$3:C3,$C$3:C3))
See the attached file. The above formula will work only if your data in column C is grouped together , so that all identical entries occur together.
Narayan