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...
I'd handle it in two steps:
1. Create a dynamic range with TAKE:
=LET(c, Sheet1!$C$3:$C$66, nonblank, COUNT(c), TAKE(c, nonblank))2. Sheet level formula then becomes:
=AVERAGE(TAKE(dynamic,-13))