I've got a set of data, a column of numbers in this case, that I want to automatically calculate moving averages for when new data is entered. Currently I'm doing this by using =TRIMMEAN($A$2:A2, 0.15)
and applying it down the column. I've tried using ARRAYFORMULA
to make this work but it doesn't seem to apply down the column when new data is added.
https://docs.google.com/spreadsheets/d/1zczXCqR-nsbvQ_QdebnAmOJEMsTr9HuqVRbzLP-qTv0/edit?usp=sharing
For example the numbers in the second column are the moving averages of the numbers in the first column. I applied the formula down the column but I'd like it to expand when new data is added into the first column, new data indicated by the red numbers in this case. I've attached a spreadsheet with the included data and my current implementation. Any help is appreciated!