Hi There,

I have a range which is filled with different City names. There are totally 10,000 City names and only 220 are unique entries.

I want a formula which will help me count the number of unique values in a range.

Please help.

Thanks in advance.

VJ