Dear Experts,
Is there any formula to count excel text & number except repeating? for example-

Column A
Karim
Rahim
Azad
Reaz
Rahim
Rahat
Azad

Here count value is 7 (counta(A1:A7) but I want to count 5 because "Azad & Rahim" is repeated. Pls help me if you know which formula count it except repeat cell value.

Advance thank you

Emran