Here's the problem:
I have a long list of countries, many of which occur several times. I want a formula which will determine how many DIFFERENT coutries there are in the list.
E.g:
China
Denmark
Denmark
Finland
Total = 3
It feels like it should be simple - but I can't do it! Thanks in advance...
I have a long list of countries, many of which occur several times. I want a formula which will determine how many DIFFERENT coutries there are in the list.
E.g:
China
Denmark
Denmark
Finland
Total = 3
It feels like it should be simple - but I can't do it! Thanks in advance...