Hi,

I have attached an excel sheet. I need to count the number of unique companies in column G, given that they are being labelled as an SME in column I.

Is that even possible?

In particular, looking at G9 and I9, using the formula on that one particular cell should yield me "3" because there are 3 unique SMEs within that cell, and if there is another instance of that particular company elsewhere, it should not add to this counter.

Thank you very much!

Book1.xlsx