Hi,
Need to make a quick countif statement.
I have a column of different countries and need to count the different ones.
For example, say column j contains:
Country of Risk
BRL
USD
USD
EUR
CAD
CAD
ZAR
BEF
GBP
GBP
i want to count the amount of "different" countries without counting the reoccurring ones twice. So in this example it would return 7 countries rather than 10. An extra bonus would be able to exclude EUR in the same formula since "EURO" is not a country but a currency. Probably a piece of cake to most of you but I cant quite get it.
Thanks in advance!
Bookmarks