I run a golf league and am looking for a formula that will average the best 5 of the last 10 scores for a person but if I add more scores it will average it off of the best 5 of the last 10 scores in a row
I run a golf league and am looking for a formula that will average the best 5 of the last 10 scores for a person but if I add more scores it will average it off of the best 5 of the last 10 scores in a row
Take a look at the LARGE function, like this:
=AVERAGE(LARGE(range,1),LARGE(range,2),LARGE(range,3) …
and so on.
Hope this helps.
Pete
Using this sample data in A1:C22
This regular formula, copied across to the right, calculates the average of the smallest 5 scores of the last 10 scores.Please Login or Register to view this content.
If there are less than 10 scores the result is N/A
That formula is durable against missing scores.Please Login or Register to view this content.
In that example, these are the results: 70.6 and 70.8
Is that something you can work with?
Ron I can't seem to view your formula
and can I do it with a row?
Will it work for a google drive spreadsheet?
Not sure about Google docs.
If it does work then you should be able to use it for rows.
In A1:O3
Please Login or Register to view this content.
Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks