How to take a row of 10 numbers, extract the 5 highest and averaging the rest

[fcpceo]

This is similar to what the GHIN handicap program does with 20 numbers. I Need help finding a way to embed an algorithm in an Excel program that would take a row of 10 numbers, disregard the 5 highest and average only the 5 lowest numbers in the group. It is similar what the GHIN handicap program does. I want to embed an algorithm at the end of a row of 10. Can the algorithm be embedded in 1 or 2 cells at the end of the row?

This is for a group of retirees that play golf together 3 times a week. I record the scores, update the program and issue a new sheet weekly. We want to find a way to throw out the highest scores because they unnecessarily inflate handicaps. Please help.

[TMS]

Try something like:

Please Login or Register  to view this content.

[tim201110]

with 10 rand and unique numbers

[TMS]

jeffreybrown has rightly suggested to me that a simpler alternative would be

Please Login or Register  to view this content.

I think I was just over analysing the problem based on the requirement to disregard the largest 5 numbers

[fcpceo]

Thanks for the help! I inserted it changing the field to B93 - K93 and wrote the equation as you sent it but got an error. It showed at error when I got to SUM(LARGE(

[TMS]

Try:

Please Login or Register  to view this content.

Or:

Please Login or Register  to view this content.

[TMS]

You might need to change commas to semi-colons for Regional settings.

[fcpceo]

It works!! I can't thank you enough.

[TMS]

You're welcome.



If you are satisfied with the solution(s) provided, please mark your thread as Solved.


New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save


You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.