Hi,

I have a question. Lets say i have an excel with some data. I need to count in a column(or a row) all the unique entries.

for example
Name
1 John
2 george
3 Merlin
4 Darko
5 George
6
7 Pikachu
8 Superman
9 Drado

I want to count how many Unique names appear on the excel, not the total number of names. What is the exact formula?

Thank you