hello all,

Advice please. The best way to look for unique records. Sample below. Have
3 columns. Need to find a debit or credit that does not have a matching
credit or debit, per invoice. Possible to delete all matches and leave only
the those without? In the sample, the last one for each invoice has no match.
When sorting, does blank lines, columns hurt? As always, your help is much
appreciated.

Susan

A B C
Invoice Debit Credit
CAT123-4 19,063.00
CAT123-4 190.63 0
CAT123-4 19,063.00
CAT123-4 190.63
CAT123-4 0 9,499.00
CAT123-4 94.99 0
CAT123-4 9,499.00
CAT123-4 94.99
CAT123-4 250.25
CAT123-4 2.50
BAT321-6 0 81,648.00
BAT321-6 81,648.00
BAT321-6 0 39,060.00
BAT321-6 39,060.00
BAT321-6 0 48,762.00
BAT321-6 48,762.00
BAT321-6 0 10,219.40
BAT321-6 102.19 0