Count function

[danialier]

Hello,

I have a group of five products as follows:

A

B

C

D

A

I need a formula that returns the number of different products, so it should return 4 (A, B, C, D). I used "count" but it gives 5 (Ax2, B, C, D).

Could you please help ?

thks,dani

[giakoum]

Thank you HIC.

I deleted my reply so that I do not confuse anybody.