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.


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"Craig" wrote:

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