I run a clay pigeon shooting ground and we are running a series of 6 events to find the Winter Series Champion.
I have a piece of software that will give me the winners of each event outputted to Excel worksheets I will merge these events into 1 spreadsheet this I can do.
What I need is an Excel spreadsheet that works with a number of worksheets.
Currently I need 6 worksheets that would have very similar data Shooters name, how many kills, the points allocated and a CPSA number for the competitor.
From the 6 events I need to work out the names of the people scoring the most points from 2 events (worksheets).
Each entrant will have a unique number associated with them in the CPSA Column.
We need to sort all the shooters that have taken part over the 6 events and put their scores in a row where we can then find the two highest scores from the events.
Some entrants will not attend all events but as long as they have two valid scores then they can be included.
However sometimes we only use 4 events so the formula needs to ask how many scores do we need from how many events.
The version of Excel we have is Excel 97 SR1 from Office 97 install. So it must work with this.