formula to count line content but without duplicate entry

Hi All
I suppose that already asked but I not found it but I'm looking one formule to count entry I have in one column but wihtout duplicate data
something like

toto
titi
toto
tata
toto

total 3
Thank in advance for your help in this matter
Regards

Kang.

Try this:

=SUMPRODUCT(1/COUNTIF(A1:A5,A1:A5))

Thank for your support
And all the best for the new Year 2018

You're welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.