Hello All, I am trying to add up the number of countries a specific show is airing. However, I also need to keep track of the clients airing these shows. Below is an example of what I am talking about:
SHOW 1:
Columa A: Column B:
Client A. CANADA
Client A. USA
Client B. ESPANA
Client B. MEXICO
Client B. USA
As you can see we have USA twice. Is it possible to create a formula to add up all the countries and only add USA only once so it can add up to 4 countries? I am required to keep the clients and countries together.
Thanks
Bookmarks