Hi! I need help to simplify this process.
Is there a shortcut formula to get the average of % difference from one row to the next row in column A without me computing the difference of per row and then taking the average after?
e.g.
A (Amount) B (difference from lower to higher)
8840 1.26%
8730 1.28%
8620 1.29%
8510 1.31%
8400
1.28% Ave difference (i need to get shortcut formula for this)
Thank you very much!
Is there a shortcut formula to get the average of % difference from one row to the next row in column A without me computing the difference of per row and then taking the average after?
e.g.
A (Amount) B (difference from lower to higher)
8840 1.26%
8730 1.28%
8620 1.29%
8510 1.31%
8400
1.28% Ave difference (i need to get shortcut formula for this)
Thank you very much!