NB! The formula shown "ANN_INFL" is supposed to say "... ROW()-2", not "... ROW()-1".
Hi everyone, I am trying to apply my formula to an array of numbers using MAP and LAMBDA, but I want the formula to start at the second number and not the first. When I MAP the array, x will always start at the first number, but I need x to start at the second number in the array. Some context:
This is my data and my formula:
ss1.png
ss2.png
From the data I have made the formula "AVG_CPI" to aggregate the CPI numbers from column B into yearly averages such that I have an annual CPI from 1985 to 2023.
In column D is what it prints out.
The formula "ANN_INFL" MAPs the annual CPI numbers (as demonstrated displayed in column D) and calculates the inflation.
The problem is that when it is applied to the first number (44.23), it subtracts by the INDEX(array, ROW(x)-2) which will subtract by the cell above 44.23 and for some reason print out an dynamic array of all the numbers, so when looping through with the first value being a #SPILL! error, the entire array becomes errors.
How can I adjust the function "ANN_INFL" such that it skips the first number and x is actually the second number?
Thank you for help
File is uploaded as well.
Bookmarks