Hello, lets say I have 360 days of data (I insert data everyday) and I want to know what is the average of the last 8 days are. Is there a formula for that?
This is a formula I use for the last digit in the column: =LOOKUP(9.99999999999999E+307,A1:A100) Maybe there is a formula just like this but for average.
Last edited by sovietchild; 02-20-2017 at 03:37 PM.
=average(index(b2:b18,match(max(a2:a18)-8,a2:a18,)):b18)
It worked. Thank you so much!Originally Posted by tim201110
Test the this formula.Formula:
Please Login or Register to view this content.
Test the this formula.Formula:Please Login or Register to view this content.
This formula gave me an error. "There is a problem with this formula."
Try
=SUM(INDEX(B2:B18*(A2:A18=LARGE(A2:A18,{1,2,3,4,5,6,7,8})),0))/8
Another alternative ... create a Named Formula called nrLast, for example:Formula:Please Login or Register to view this content.
Then you can use the formula:Formula:Please Login or Register to view this content.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks