Hello,
I have seen this formula work before, where all I did was copy and paste. I didn't keep a copy of it and am not able to find it to replicate.
I am looking for a formula that will subtotal in a seperate column using "At each change" data from another column, and totaling from a Debit column less a Credit column.
There can be multipul rows containing the same SO# due to multipul line items. I had seen that when there are multipul rows, that only the last row containing the same SO# would physically show the balance, whereas the other rows with the same SO# would be whited out, but the formula would show in the formula line.
If you can help me, I would appreciate it very much.
I've shown a screen shot below for an example;
Debit Credit So# Total
0.00 53,130.00 37806 - Total cell will contain formula but be whited out
0.00 1,820.00 37806 $$$ - This cell will contain formula but be visable, showing the grand total of the SO#
4,102.60 .00 38146 $$$ - This cell will contain the formul be be visable, showing the grand total of the SO#