Finding Duplicates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
This only helps me identifyif there are duplicates in column A. My
spreadsheet looks something like this. What I am trying to reduce my
spreadsheet to is rows 1, 2, 4, 5. Rows 3 & 6 & 7 are the same as rows 1 & 2
& 4 but in opposite order. I hope this makes sense

1111 0 a 2222
1234 0 a 5678
2222 0 b 1111
2345 0 a 7890
5555 0 a 6666
5678 0 b 1234
7890 0 b 2345
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Duplicate Function Help 1
Prevent Duplicate Records 6
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
how do i sort a spread sheet and remove duplication 3
comparing columns in two spreadsheets 1
How to delete duplicates and also count them 3
What type of "lookup" 3

Back
Top