@DBrazil - Would it work to create a custom pivot table report with last name and first name in the rows and count of contact in the values. Order the table by highest contact of contacts descending. Any with a value of 2 (or higher) could potentially be duplicates. Like this:
In the fields, add email and record ID, so when you click on the count of contacts number that is a 2 or higher, it shows you which record has the email address assigned and also a hyperlinked record ID to take you to the records to merge as required:
Figured it out now - however, the issue I’m hitting is that there are too many records (4163) for the report to create. In preview mode I can tell it is working as per the design you shared.
What I’m trying to do - and succeeding - is to filer so that it only picks out records where count of contacts is greater than 1. But I can’t pull that into the filter criteria.
Any suggestions?
-- Update -- I ended up exporting as a CSV and doing the analysis that way which wasn’t too bad - however, still keen to know if I missed anything to keep in internal to Hubspot