Hi all,
I have searched far and wide and have not been able to find a solution. Bascically I need to search down column T to find the first zero (Which is a SUM formula) then delete the rows linked to that zero total, then find the next one a so on.
For example in Colums T and U:
148.88 21786872
-148.88 21786872
-148.88 21786872
148.88 21786872
0
150.75 21786873
-150.75 21786873
-150.75 21786873
150.75 21786873
-150.75 21786873
150.75 21786873
0
1,807.00 63606001
-1,807.00 63606001
1,807.00 63606001
1,807.00
I would like to have this end up showing just the 3 rows with the +/-1,807.00 values, as well as the total.
Any help would be greatly appreciated.