1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Auto-average 4 most recent numbers in a row

Is there a formula I can write that is always averaging the most recent 4 entries of a row rather than me having to change the formula every week? For example (image link below), I want it to automatically average C2:F2 once I enter F2, instead of me having to manually change the code in L2.

I have tried the following:

=AVERAGE(TAKE(FILTER(A2:J2, ISNUMBER(A2:J2)),-4)) but that only gives me the average of the first 4 cells, A2:D2. I tried changing the -4 to just 4 but that still doesn't work.

Can’t figure out how to insert image into a text post on iOS so here is a link: https://imgur.com/a/MDaPbhW

Thank you!

submitted by /u/creaturelogic
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com
#AI formula generation techniques
#Excel alternatives for data analysis
#formula generator
#row zero
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#no-code spreadsheet solutions
#Excel alternatives
#average
#formula
#recent
#entries
#automatically
#C2:F2
#F2
#A2:J2
#manual
#ISNUMBER