Quick way to elimate BOTH identical records?

  • Thread starter Thread starter Craig
  • Start date Start date
C

Craig

Hi,

I have a large list of 2 columns titled Check number and Amount

Where there's a duplicate set of 2 records (same check number and same
amount) I want to not only delete the duplicate but the original record
too...so is there a quick way to search through a large list, identify any 2
duplicate record sets and delete BOTH of them?

thank you very much for sharing any knowledge, insight on this matter!

Craig
 
I would use 2 extra columns.

In the first one, you concatenate Check number and Amount, for instance with
a character like §. Pay attention to numbers with decimal numbers.

In the second column, use a COUNTIF function to count the no. of ocurrences
of each concatenated string.

Lastly, apply an autofilter and delete the rows how occur 2 or more times in
the concatenated column.
 
Back
Top