•1 min read•from 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!
[link] [comments]
Want to read more?
Check out the full article on the original site
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