Counting number of items excluding duplicates.

  • Thread starter Thread starter julian.avery
  • Start date Start date
J

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.
 
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
Click to expand...

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



Regards
Claus B.
 
Back
Top