Filtering

[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

 

[Anne903]

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

 

[Susan]

Hello Anne,
That's what I need too! But I need that invoice number to go along with it.

 

[Anne903]

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

 

[Pete_UK]

It you look at this link:

http://groups.google.com/group/micr...?lnk=gst&q=maddening+dilemma#53cf74db4b0e3e21

you will see a macro (and formula) solution for doing a similar thing
to what you are trying to do - perhaps you can amend it to suit your
particular circumstances. The thread developed over several days, and
branched in several directions, so have a read through it all, then
come back if you need further help.

Hope this helps.

Pete

 

[Susan]

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

 

[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