Check 2 Columns for duplicate values and Combine into Parent Child

Frank H Smith

I have a sheet where we capture name and e-mail. I want to check the sheet to see of these match and if they do, combine the duplicates into a parent child relationship with the first entry being the parent. I already capture the creation information so establishing the first entry should not be a problem.

Any suggestions?

David Joyeuse

As far as I know, there's no way to automatically combine rows in a parent/child hierarchy.

Now, if you want to do this so you only display each name/address once, I can suggest you a workaround to this.

Add an helper column named "Duplicate" (flag type column) with this formula:

=IF(COUNTIF([Name]$1:[Name]@row,[Name]@row,[EMail]$1:[EMail]@row,[Email]@row)>1,1,0)

This will check if the name/email address combo was previously entered.

Then create a report out of this that only show rows where duplicate is at 0.