Hi guys.
I stumbled across this site purely by accident and I'm hoping someone can help me out with a little problem I've got.
I've made some score sheets for the shooting team I'm a member of, that keep a record of all the individual points scored over the course of a season (eleven rounds).
It took me a while (I'm still a relative novice when it comes to excel) but I got there in the end.
As the scores are entered on the sheet, the average of the last six scores are calculated and displayed at the end of each row as a percentage.
This is a 'rolling' average, ie rounds 1 to 6 will give an average, then 2 to 7, 3 to 8, etc.
The problem is, I now need to work out a formula that will take these last six scores and give me the best five out of the six.
I hope I've explained it well enough (probably not ) so does anyone think they can help?
It would be greatly appreciated.
Iain
I stumbled across this site purely by accident and I'm hoping someone can help me out with a little problem I've got.
I've made some score sheets for the shooting team I'm a member of, that keep a record of all the individual points scored over the course of a season (eleven rounds).
It took me a while (I'm still a relative novice when it comes to excel) but I got there in the end.
As the scores are entered on the sheet, the average of the last six scores are calculated and displayed at the end of each row as a percentage.
This is a 'rolling' average, ie rounds 1 to 6 will give an average, then 2 to 7, 3 to 8, etc.
The problem is, I now need to work out a formula that will take these last six scores and give me the best five out of the six.
I hope I've explained it well enough (probably not ) so does anyone think they can help?
It would be greatly appreciated.
Iain