How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask NewITZone Your Own Question

NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
Experience:  I have been using Office Pro for 10 years and implemented applications for business use.
53509759
Type Your Microsoft Office Question Here...
NewITZone is online now
A new question is answered every 9 seconds

I want an easy way to extract date from a ski race. We have

Customer Question

I want an easy way to extract date from a ski race. We have formed a fun team event. There are 5 athletes per team. I want to know which team has the lowest combined time from their top 3 racers to award 1st, 2nd and 3rd place in the team event. Each top 3 must have at least one athlete per gender. So for instance, if a team's top 3 times are all boys, then I need to calculate the result based on the top 2 boys and top girl on the team, and vice versa. There will be 250 athletes and 50 teams.
Submitted: 9 months ago.
Category: Microsoft Office
Expert:  The-PC-Guy replied 9 months ago.

before I could tell you whats possible I would need to see an example file of how the data is arranged.

Customer: replied 9 months ago.
I can arrange things differently than what I have if need be, but I am looking at the "Best of" results for doing the final calculation and with 250 athletes it is a lot of data.
Expert:  The-PC-Guy replied 9 months ago.

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

Customer: replied 9 months ago.
The highest 3 people per team, but must include at least one athlete from each gender. Then I want the top three teams.
Expert:  The-PC-Guy replied 9 months ago.

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?

Customer: replied 9 months ago.
except you want the lowest total - so fastest time. And each team's totals need to include only top 3 fastest times per team with at least one of each gender.
Expert:  The-PC-Guy replied 9 months ago.

that would mean you are esentially looking for the top 9 people.

top 3 teams and top 3 people from each of those teams.

Customer: replied 9 months ago.
except you could have one really fast athlete who's time, when combined with the two slowest athletes, is still faster than the other combined times.
Expert:  The-PC-Guy replied 9 months ago.

which is why I think each team would need to be totaled and we would use that time

Customer: replied 9 months ago.
Is there a way to total each team then to also automatically calculate the top 3, not included the bottom two slowest times and include both genders?
Expert:  The-PC-Guy replied 9 months ago.

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.

Customer: replied 9 months ago.
I have version 14.6.1
Expert:  The-PC-Guy replied 9 months ago.

doesn't help. What years is that please.

Expert:  The-PC-Guy replied 9 months ago.

and is it mac or windows

Customer: replied 9 months ago.
Sorry - for a Mac and 2011
Expert:  The-PC-Guy replied 9 months ago.

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.

Customer: replied 9 months ago.
Fair enough - I can spend the time manually sorting out the results on race day. I will ask our TD whether we would be doing this often enough to justify spending the money to have it built.Thank you,
Expert:  The-PC-Guy replied 9 months ago.

so for now you want to hold off.

Customer: replied 9 months ago.
hold off for now. I will connect with my TD and see what they want to do. We may change the way we calculate the results for the event to make it easier as well for us on race day. Thank you!
Expert:  The-PC-Guy replied 9 months ago.

alright when you are ready to continue let me know

Related Microsoft Office Questions