Excel How to average last 10 (non-blank) entries in Excel

[Betsy]

I am using an Excel spread sheet to record the golf scores of multiple players and would like to average the last ten non-blank entries.

Can anyone help?
Betsy

 

[Ian]

You should be able to add a formula to a cell such as:

=AVERAGE(A1:A10)

That will give you the average from cells A1 to A10, even with blanks

 

[Betsy]

Hi Ian,
Thanks for the reply but I am looking for more than a simple average. Let me explain. My spreadsheet records the date and daily score for numerous golfers. Any golfer that does not play on a particular date will have a blank record. Each player has dozens of entries and I want to automatically average the last ten entries for each player.
Can you help?
Betsy

 

[Ian]

Ah, I see Betsy - I think the only way to do that would be to use VB Script in Excel - I will have a think and see it would be done, or think of an easier way.