Not really sure what are after but here is something that maybe helpful to you
To get the last row
Formula:
=MATCH(10^308,E:E)
If you want to create a cell reference from it:
Formula:
=INDIRECT("E"&MATCH(10^308,E:E))
and if you want to include it in your formula in K5
Formula:
=AVERAGE(INDIRECT("E"&MATCH(10^308,E:E)):OFFSET(INDIRECT("E"&MATCH(10^308,E:E)),I5+1,,,))
Or better use INDEX
Formula:
=INDEX(E:E,MATCH(10^308,E:E))
and
Formula:
=AVERAGE(INDEX(E:E,MATCH(10^308,E:E)):OFFSET(INDEX(E:E,MATCH(10^308,E:E)),I5+1,,,))
Bookmarks