golf scores

[Golf.nut1]

I would like to make up a spreadsheet for golf handicaps
where only the last 5 scored entered in a row are
counted. When new scores are added, only the last 5
entered are still counted. Do you know how I can do this?

 

[Peo Sjoblom]

Do a Google search for that, this question or a similar seems to be posted
with a regular frequency

Here's an example


=AVERAGE(V2:INDEX(A2:V2,LARGE(COLUMN(A:V)*(A2:V2<>""),5)))

entered with ctrl + shift & enter

this example starts in A2 going to V2

 

[Gord Dibben]

Golf.nut

Info only.......

USGA rules demand lowest 10 out of last 20 scores for valid handicap.

Gord Dibben Excel MVP