Golf averages

[Guest]

There are 24 players in my golf league. I would like to get a running average
of the last scores midway thru the season which runs for 20 weeks. I need the
average of the last 8 scores submitted and not just an average of the last 8
weeks which could have one or more missing scores.
51
52
49
46
42
43
43
45
43
45
47
39

44

45
47

50

 

[Biff]

Hi!

Try this entered as array using the key combo of CTRL,SHIFT,ENTER:

=AVERAGE(A100:INDEX(A1:A100,LARGE(IF(A1:A100<>"",ROW(A1:A100)),8)))

Use a big enough range to cover any future entries!

Biff

 

[Domenic]

Try...

=AVERAGE(INDEX(A1:A20,LARGE(IF(A1:A20<>"",ROW(A1:A20)-ROW(A1)+1),8)):INDE
X(A1:A20,MATCH(9.99999999999999E+307,A1:A20)))

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER.

Hope this helps!