Excel find and remove duplicate row pairs that have switched values
<p>I have a list of rows that match account info by similarity</p>

<p>John | Bonham  | 123 Main St  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| (555)555-5512 | &nbsp;&nbsp;<strong>-1-</strong><br>
John | Bonham  | 854 Local St &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| (555)555-1111 | &nbsp;&nbsp;<strong>-1-</strong><br>
John | Bonham  | 123 Main St  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| (555)555-5512 | &nbsp;&nbsp;<br>
John | Bonham  | 121 Mission St &nbsp;&nbsp;&nbsp;&nbsp;| (555)555-1234 | <br>
John | Brown&nbsp;&nbsp;&nbsp; | 555 Some Ave &nbsp;&nbsp;&nbsp; | (555)555-2323 |<br>
John | Bell&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; | 434 Uptown Blvd  | (555)555-8888 |<br>
John | Bennet&nbsp;&nbsp;&nbsp; | 666 Side Ave &nbsp;&nbsp;&nbsp;&nbsp; | (555)555-2323 |<br>
John | Baker &nbsp;&nbsp;&nbsp;&nbsp; | 484 Downy St&nbsp;&nbsp;&nbsp;&nbsp;  | (555)555-8888 |<br>
John | Bonham  | 854 Local St &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| (555)555-1111 | &nbsp;&nbsp;<strong>-2-</strong><br>
John | Bonham  | 123 Main St  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| (555)555-5512 |&nbsp;&nbsp;<strong>-2-</strong><br>
Jay &nbsp;&nbsp;| Carter&nbsp;&nbsp;&nbsp;&nbsp;  | 123 Main St  &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;| (555)555-5512 |&nbsp;&nbsp;</p>

<p>As you can see I've already found the John Bonham accounts with the first instances.  Is there an easy way I can remove the second instances of the accounts with Excel or Google Sheets?</p>

<p>Edit: I don't want to just remove duplicates.  As you can see now, there are two unique matches fo John Bonham that I want to keep.  The 123 Main matches the 854 Local and the 121 Mission.  I just want to remove the second instance of the 854 Local</p>

<p>Edit2: I guess I should have mentioned, there is no unique data.  Phone numbers do not belong to one account only.</p>