This I didn't think would be hard, but is causing me quite the headache. I have data in one column (Net Amount) that has double spaces after every few lines. In another column, I want to keep a cumulative total, but not include those spaces in the cumulative total column (I have been able to run cumulative total, but is places the same number 3 times in a row because of the empty cells in the first column). Does anyone have a function that can achieve what I mirrored below (instead of manually adding it like I did)? Thanks!
|Net Amount||Cumulative Total|
This question generated 12 answers. To proceed to the answers, click here.
This thread is current as of November 02, 2014.