See this, Fluffy:
http://www.officearticles.com/excel/...soft_excel.htm
************
Anne Troy
www.OfficeArticles.com
"fluffy" wrote in message
...
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.