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. enter image description here


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!


1 Answer 1


3 formulas derived from this site give this enter image description here

test sheet

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.