Filtering

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

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
 
Hello all I have much the same problem except I have debits and
credits in the same column. I would like a formula that would delete all
matching unique records, leaving just those with no match.
Anne
 
Hi Susan
I wasn't very clear in my "post" I also have an invoice number to go with,
its just my accounting program keeps all the debits and credits in one
column..you have to watch for the "-" sign. A real pain I must say. I would
like a formula that matches all the DR/CR from a particular invoice number,
and only prints out the ones for me that don't match....did that make sense?
Anne
 
Hello Anne,
Makes complete sense. Read Pete's reply. No programming experience here.
Will read over his reply again, might find something. Hoping this would be a
simple task.

Susan
 
Hello Pete,

Thank you. Will read over the threads again and again. Have no programming
experience. Was hoping this would be a more simple task.

Susan
 
Back
Top