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


Joined
Jul 13, 2005
Messages
2
Reaction score
0
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
 
Ad

Advertisements

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,117
Reaction score
1,066
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 :)
 
Joined
Jul 13, 2005
Messages
2
Reaction score
0
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
 
Ad

Advertisements

Ian

Administrator
Joined
Feb 23, 2002
Messages
19,117
Reaction score
1,066
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top