However here is the issue, I have about 10000 entries and so would need to do this for each row. Is there a way to automate this formula so that it will put in the correct row numbers without me needing to go in and manually edit it say 10,000 times?
Okay to help clear this up the formula would look like this without specifics..
=IF(B(current row number)>0,SUM(B(current row number)- B(current row number -1))
This needs to be applies to work on an entire column beginning at Row 3 and going down to infinity so it can cover future data. See I get the math I just do not use Excel enough to understand how to make it do what I am looking for.
Edited by ComputerEd, 07 December 2012 - 09:08 AM.