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.