Averaging dynamic rows from bottom up

[deb0578]

Good evening. Is there a way to change this formula:

=TRUNC(AVERAGE(SMALL((G?:G?),{1,2,3,4,5,6,7,8,9,10}))*0.97,1)

to apply to the last 20 numbers in Column G? Rows are added daily to the worksheet and thus, the range changes daily. Thank you for your help.

 

[T. Valko]

Good evening. Is there a way to change this formula:

=TRUNC(AVERAGE(SMALL((G?:G?),{1,2,3,4,5,6,7,8,9,10}))*0.97,1)

to apply to the last 20 numbers in Column G? Rows are added daily to the worksheet and thus, the range changes daily. Thank you for your help.

Like this...

=TRUNC(AVERAGE(SMALL(OFFSET(G2,MATCH(1E100,G2:G1000)-1,,-20),{1,2,3,4,5,6,7,8,9,10}))*0.97,1)

I use G1000 as the end of range. Adjust as needed.

Looks like golf handicaps!

 

[deb0578]

Looks like golf handicaps!

Totally busted! Works great! Thank you so much!

 

[T. Valko]

Totally busted! Works great! Thank you so much!

You're welcome. Thanks for the feedback!