I need help to determine how to calculate a moving range dynamically so that the
absolute number between two consecutive numbers in a column are determined. I need
a formula that can reference the cells without referring to their specific row #, so that the difference column will update automatically when a new number is added.
As shown below, the first cell for difference will be empty of course...then I wish
to insert a formula to calcuate the differences automatically upon entry of new month of data.
For example,
month Blood pressure Difference
jan 98
feb 99 1
march 96 3 etc.
absolute number between two consecutive numbers in a column are determined. I need
a formula that can reference the cells without referring to their specific row #, so that the difference column will update automatically when a new number is added.
As shown below, the first cell for difference will be empty of course...then I wish
to insert a formula to calcuate the differences automatically upon entry of new month of data.
For example,
month Blood pressure Difference
jan 98
feb 99 1
march 96 3 etc.