I'm desperate for some help with a formula I just cant crack!
I have a column (D) which contains names of organisations and an adjacent column containing email addresses (F). I have another column containing a country code which can be one of 6 countries (this is column I, with the options UK, USA, CAN, SA, NZ, AUS).
For some of the organisations I have several email addresses, thus in column D the organisation name sometimes appears twice or more, providing new rows for the email addresses.
I need to create a table which summarises my data telling me how many email addresses I have for each country and how many unique organisations I have for each country.
For the email addresses I have used: =COUNTIF(I1:I3279, "nz")
This works fine, returning the number of times each country code appears in the I column.
I now need to create another formula which will count the number of unique organisations I have in each country. I assume it will be something that equates to "countif D is unique and countif I is 'UK'"