Cannot find logic to delete duplicate data

[Loin75]

Hi all,

I have been handed a spreadsheet that has thousands of names and addresses extracted from a SQL database.
Each row also includes columns for their partners name (if they have one)

My problem is that if Mr John Smith has a partner (eg, Mrs Janet Smith) showing in the same row, then further down I also have an entry for Mrs Janet Smith and her partner Mr John Smith.

The extraction created a row for every client, so I have duplicate entries.

I am struggling to find logic that will help me to delete the "additional" rows. I can use MATCH formulas to identify where duplication occurs, but not sure how to remove only one of the two entries.

Has anyone come across such a thing, and can offer any logic that I am missing to help?

Many thanks in advance

 

[My Aswer Is This]

So assuming both have the same address like 1458 Elm Street
Why not look down column "B" for the address and delete all duplicates

 

[Loin75]

So assuming both have the same address like 1458 Elm Street
Why not look down column "B" for the address and delete all duplicates

Thanks. This was a consideration until i realised that we had examples of kids as well at the same address. If we removed duplicates, how can I guarantee that it deletes the 4 kids and not the main client entry?

I am also not sure if I should be deleting these child entries just yet anyway. I would probably prefer to keep these until i hear otherwise from my Supervisors.