What about the duplicate entries....
If a value is repeated thrice i want that to be counted as once.
i dont know if im clear
A1 = India
A2 = India
A3 = Australia
A4 = America
in B1 i want a formula where in it should count unique entries which means i actually have 3 entries (India is repeated twice)