before I could tell you whats possible I would need to see an example file of how the data is arranged.
are you looking for the highest 3 people total or per team name, and how do you want results displayed.
Also if gender is a criteria that should be in its own column
so first each team would need to have a total, right? so you are looking for the top 3 teams that would be the top 3 teams with the highest total?
that would mean you are esentially looking for the top 9 people.
top 3 teams and top 3 people from each of those teams.
which is why I think each team would need to be totaled and we would use that time
i am thinking that this is too complicated for a formula though. I think you will need some kind of macro, which I could program.
Which version of excel do you have.
doesn't help. What years is that please.
and is it mac or windows
that version should support it, but I cant guarantee complete comparability.
This is actually a very complicated problem, I think it can be done with the macro. Essentially you would enter all the information then click and button, and it would create columns, and label first 2nd 3rd 4th 5th person, all the way to 9th, top 3 teams 3 people per team.
I can't do this for less than $120.
so for now you want to hold off.
alright when you are ready to continue let me know