Forum Discussion
Average TAKE for rolling dates
I am trying to create an excel sheet that averages bottom 13 rows, with new rows being added weekly for new data. How to I have excel only average the most recent 13 values in a data set, but ig...
=AVERAGE(INDEX($C$3:$C$66,LARGE(IF($C$3:$C$66<>"",ROW($C$3:$C$66)),1)-2):INDEX($C$3:$C$66,LARGE(IF($C$3:$C$66<>"",ROW($C$3:$C$66)),13)-2))An alternative with older versions of Excel could be this formula. The formula has to be entered with ctrl+shift+enter if one doesn't work with Office 365 or Excel 2021.