Golf Leage Help

[David]

Hello, I need an average of last 6 scores discounting the lowest and the
highest. I need to also discount blanks/zero for days the person does not
show. Thank you for your time and patience with me.

 

[Jason Lepack]

What is the current layout of your spreadsheet?

Cheers,
Jason Lepack

 

[David]

Thank you, Jason. I am planning to list the dates in row 1, column b and
across. The players will be listed in column a and the player scores
corresponding to the names and dates. I am planning to link the result of
the averages to worksheet 2 which will show the player and the average.
Thank you

 

[JLGWhiz]

This site might interest you, also.

http://www.sharewareconnection.com/list.php?categ=406500&page=2&criteria=name

That should all be one line if you copy and paste it.

 

[Jason Lepack]

This is an array formula, it must be entered using Ctrl+Shift+Enter.

=AVERAGE(INDEX(B2:IV2,LARGE(IF(B2:IV2<>"",COLUMN(B2:IV2)-COLUMN(B2)+1),
6)):INDEX(B2:IV2,MATCH(9.99999999999999E+307,B2:IV2)))

Cheers,
Jason Lepack

 

[Jason Lepack]

http://www.dailydoseofexcel.com/archives/2005/08/18/golf-handicap/

 

[David]

Thank you, Jason, you have been a big help to me and to our league. God
bless you and Excel!

 

[David]

Jason, I did some experimenting with the array formula that you sent to me
and it works like a charm for averaging the last six scores. My problem is
the formula includes zeros and it should not (in the event the player does
not play that day we do not want to include it in the average) and the
formula does not appear to throw out the highest of the last six and the
lowest of the last six. Would you either help me repair the formula or
would you fix it for me? I understand some of the formula but not the
majority of it. Thank you very much for your patience with me.

 

[Jason Lepack]

I figured that out, and I don't have time to look at it right now.

That's why I posted the link.
http://www.dailydoseofexcel.com/archives/2005/08/18/golf-handicap/

Cheers,
Jason Lepack