Counting number of items excluding duplicates.

[julian.avery]

I currently have a table of 120 products that includes duplicates.
I would like to count how many different products are included in this 120.
For example:

Product
A
A
A
B
C
C
F
E

There are 8 total products listed, but only 5 different products.
Is there a way to count how many different products are listed.

I tried a pivot table but I don't need the total each product is listed, just the total number of products.

 

[Claus Busch]

Hi,

Am Thu, 17 Oct 2013 06:42:22 -0700 (PDT) schrieb (e-mail address removed):

Product
A
A
A
B
C
C
F
E

your products in column A with header. Then try:
=SUMPRODUCT((A2:A200<>"")/COUNTIF(A2:A200,A2:A200&""))



Regards
Claus B.