I have a spreadsheet that has in column A an account number and in column D
the another account number tied to the first. However, the report also has
the tied account number from column D in column A and vice versa. I need to
find the duplicate listing of accounts and remove one of the rows. Is there
a formula that can do this.