0

I have attached a pic of what I am trying to do. The goal is to get LAMBDA to subtract the previous cell and then average that. (AVERAGE RATE OF CHANGE)

ZygD
  • 22,092
  • 39
  • 79
  • 102
PrimusAlphinex
  • 1
  • 2
  • What is your excel version? LAMBDA() is only available Excel 365 latest release. – Harun24hr Jun 26 '22 at 07:34
  • 1
    I can't reproduce the error, it runs fine on my setup. Might be worth mentioning that the average rate of change is just (last value - first value) / (number of values - 1) i.e. 1/24 for your data. – Tom Sharpe Jun 26 '22 at 08:04
  • @TomSharpe This nugget of information is what I was looking for! Thanks – PrimusAlphinex Jun 26 '22 at 16:24

0 Answers0