I would like to calculate the difference between the value of a cell and the average value of previous 10 cells in the same column.
Data is arranged in 3 columns: Date, value, value-mean.
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
How to calculate delta value of current cell - previous 10 day average
0
Answers
0
=B11-average(B1:B10)