Count Unique and Duplicate Contacts based on Company, FirstName and Last Name

[Bargy7]

Good day,

I was hoping I may be able to receive advice around how I could use Excel to support the analysis I am trying to go through.

I have mocked up the spreadsheet attached to demonstrate how this looks with the real data removed.

My intention is for a ‘Summary’ tab on tab 1 to show an overview of what the data presents. Tab 2 holds the raw data.

The goal of what I wish to present is as follows:
o For Tab 1, cell B8 to be a sum of unique campaigns from column A on Tab 2. For example, the answer should appear as 3 but I can’t seem to get this working.
o For Tab 1, cell B9 to be a sum of total unique contacts within the entire list, however, it’s likely there may be duplicate contacts in there who have participated in different campaigns, such as the case on Tab 2, Row 2 for Company Alpha, John David (appearing in campaign 1, 2 and 3). Therefore I’m trying to get this to count up the unique contacts, but also count the duplicate names against the ‘Reengaged Contacts’ on Tab 1, Cell B9. It may be worth commenting that there will never be duplicate contacts for the same campaign, but two people could have the same name. My thought was to try do a COUNTIF based on the persons company, first name and last name to try get exact matches
o Lastly, on Tab 2, column E, I was hoping this could show a count of how many times each contact appears in the list.

Any help would be greatly appreciated as I continue to learn and improve my Excel abilities.


Kind regards,

John