Reply to thread

Message: [QUOTE="rjr, post: 6200180"] Thanks for responding, The columns that I want removed would be gone leaving only the two columns left to provide the data. The rows would need to be "sorted" or better comment, if they fit the criteria of "I need to process only the CO Code that has 3DFGU; 3DFGV; 3DFGW AND 3DFGX. " YES; Any rows that have these combo's should stay, with the remainder not fitting the criteria being removed as in "Gone". When doing the "sort" for this group of four there will be others included as the criteria always has an additional two characters in them. This may help: 3DFGUXA; 3DFGUWE; 3DGUIS; 3DHUIS; 3DHUON etc. the first 3 would show up under the 3DFGU and the last two would be discarded because they don't fit in the criteria. I take it that you want to keep all those rows that have, as the first 5 YES The first row holds the header and it will be reduced to : "AGING" and "CO CODE" Summary: I should end up with only the 4 codes listed under the CO CODE, and would like a subtotal of each main branch and it should represent how many entries for that CODE. Under Aging, I would need to have the subtotal show the oldest amount of days in that group. While the group may have aging days of 1,3,6,8,14, & 23; I would want it to show the 23 as the oldest aging date. I was able to use the MAXA function but don't know how to include it in a macro or programming. Thanks, BOB [/QUOTE]