The concatenation would be a invoice number followed by a part number. It would look something like the following: 93JAL312IHO35#ABBA. This is based on a invoice number 93JAL312I and a part number HO35#ABBA. I then make a new column based on the concatenation and do the following =left(d2,13).
B C D E F Z
Invoice Number Date Concatenation Trimmed Part Number....... Amount Balance
93JAL312I 12/25/10 93JAL312IHO35#ABBA 93JAL312IHO35 HO35#ABBA 0
93JAL312I 12/25/10 93JAL312IHO35#ABBA 93JAL312IHO35 HO35#ABBA 149
21320JJ2I 12/25/10 21320JJ2IDCD5#ABBA 21320JJ2IDCD5 DCD5#ABBA 1301
J12N32FA2 12/25/10 J12N32FA2AAD5#ABBA J12N32FA2AAD3 AAD3#ABBA 0
J12N32FA2 12/25/10 J12N32FA2AAD35#ABBA J12N32FA2AAD3 AAD3#ABBA 0
This will go on for thousands and thousands of lines. Making the subtotal calculation time a very long time to calculate. My only goal is to delete each group of identical trimmed concatenations with a sum of amount balances equal to 0. I end up removing the subtotals immediately after which can also take a long time to complete. I'm trying to avoid subtotaling everything. I don't know if there is a way you can sort the data so that you only have to subtotal a portion of the document. Or maybe if there is a way to achieve the same result with quicker process.