|
Filtering
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 |
Filtering
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" wrote: 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 |
Filtering
Hello Anne,
That's what I need too! But I need that invoice number to go along with it. "Anne903" wrote: 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" wrote: 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 |
Filtering
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 "Susan" wrote: Hello Anne, That's what I need too! But I need that invoice number to go along with it. "Anne903" wrote: 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" wrote: 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 |
Filtering
It you look at this link:
http://groups.google.com/group/micro...7 4db4b0e3e21 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 On Jul 24, 11:09*pm, Anne903 wrote: 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 "Susan" wrote: Hello Anne, That's what I need too! But I need that invoice number to go along with it. "Anne903" wrote: *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" wrote: 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- Hide quoted text - - Show quoted text - |
Filtering
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 "Anne903" wrote: 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 "Susan" wrote: Hello Anne, That's what I need too! But I need that invoice number to go along with it. "Anne903" wrote: 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" wrote: 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 |
Filtering
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 "Pete_UK" wrote: It you look at this link: http://groups.google.com/group/micro...7 4db4b0e3e21 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 On Jul 24, 11:09 pm, Anne903 wrote: 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 "Susan" wrote: Hello Anne, That's what I need too! But I need that invoice number to go along with it. "Anne903" wrote: 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" wrote: 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- Hide quoted text - - Show quoted text - |
| All times are GMT +1. The time now is 09:37 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com