golf scores

  • Thread starter Thread starter Golf.nut1
  • Start date Start date
G

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?
 
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
 
Golf.nut

Info only.......

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

Gord Dibben Excel MVP
 
Back
Top