Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

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

Customer Question
I want an easy way...
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: 2 years ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 3 minutes by:
2/29/2016
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago
The-PC-Guy
The-PC-Guy, Computer Manager
Category: Microsoft Office
Satisfied Customers: 2,189
Experience: 20 years experience providing remote computer support
Verified

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

Ask Your Own Microsoft Office Question
Customer reply replied 2 years 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.
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years 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

Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
The highest 3 people per team, but must include at least one athlete from each gender. Then I want the top three teams.
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years 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?

Ask Your Own Microsoft Office Question
Customer reply replied 2 years 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.
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years 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.

Ask Your Own Microsoft Office Question
Customer reply replied 2 years 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.
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago

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

Ask Your Own Microsoft Office Question
Customer reply replied 2 years 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?
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years 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.

Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
I have version 14.6.1
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago

doesn't help. What years is that please.

Ask Your Own Microsoft Office Question
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago

and is it mac or windows

Ask Your Own Microsoft Office Question
Customer reply replied 2 years ago
Sorry - for a Mac and 2011
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years 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.

Ask Your Own Microsoft Office Question
Customer reply replied 2 years 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,
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago

so for now you want to hold off.

Ask Your Own Microsoft Office Question
Customer reply replied 2 years 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!
Microsoft Office Technician: The-PC-Guy, Computer Manager replied 2 years ago

alright when you are ready to continue let me know

Ask Your Own Microsoft Office Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a microsoft office technicianLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask NewITZone Your Own Question
NewITZone
NewITZone
NewITZone, Computer Enthusiast
Category: Microsoft Office
Satisfied Customers: 90
90 Satisfied Customers
Experience: I have been using Office Pro for 10 years and implemented applications for business use.

NewITZone is online now

A new question is answered every 9 seconds

How JustAnswer works:

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

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

701 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

2,189 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

IT Miro

IT Miro

Computer Scientist

157 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

Chris L.

Chris L.

Support Specialist

147 satisfied customers

Certified Expert with over 10 years experience.

< Previous | Next >

Related Microsoft Office Questions
I have an Macbook pro and I need to reinstall my Office 2011
Hi Pearl, I have an Macbook pro and I need to reinstall my Office 2011 because my apple id changed … read more
John Castle
John Castle
BSC in Computing Network Management and Design
43 satisfied customers
It appears that I inadvertently deleted my Word and Excel
It appears that I inadvertently deleted my Word and Excel programme … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
701 satisfied customers
I have a Microsoft word 7 document suddenly switched from
I have a Microsoft word 7 document suddenly switched from draft to page view and is stuck there! How can I get it back to draft? … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I have just replaced my MMacBook Air with a new one. I
I have just replaced my MMacBook Air with a new one. I cannot find the password ***** username to open Microsoft Office … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I forgot my password and would like to reset. i can't open
i forgot my password ***** would like to reset. i can't open my desktop ,am now on a laptop … read more
Jeevan DSouza
Jeevan DSouza
Professor
PhD
6 satisfied customers
Typed in my proper Microsoft account password and it did not
Typed in my proper Microsoft account password ***** it did not go through. I need to reset. … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
701 satisfied customers
I use excel2007. The details on one of my worksheet do not
I use excel2007. The details on one of my worksheet do not show. just a blank screen. how do I get them back … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
Saved a *.docx file on my desktop. It disappeared from my
Saved a *.docx file on my desktop. It disappeared from my desktop. Opened Word/Recent. The file was there. Tried to open it. Access denied. … read more
Jason Jones
Jason Jones
AAS Information Technology
6,324 satisfied customers
I did a restore point on my computer, at this point I am use
I did a restore point on my computer, at this point I am use my daughter computer. I have lost my password ***** can not get in to my computer which is in another room. Can you help with restoring my … read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
969 satisfied customers
I have been waiting over 8 minutes which was my estimated
Second opinion] I have been waiting over 8 minutes which was my estimated time for an answer - are you going to help ?… read more
murpmi00
murpmi00
BS of Science
4 satisfied customers
My Surface crashed last year following a Windows update;
My Surface crashed last year following a Windows update; Microsoft replaced it with a new one, but I was told that all data was lost. But if I saved things to OneDrive, it seems like I should be able … read more
bbao
bbao
Freelance IT Consultant
74 satisfied customers
I have a document in Word of 8 sections each with a section
I have a document in Word of 8 sections each with a section break. I want to insert a different header for each section but when I do the headers for the whole document take on the latest header I hav… read more
George Sibiya
George Sibiya
PhD
298 satisfied customers
Having trouble opening an asd file. Office word 2013. I can
i can open it the program fine, but when i try to open the asd program i just get symbols … read more
Jess M.
Jess M.
Computer Support Specialist
Bachelor's Degree
701 satisfied customers
I'm desperately trying to reconnect my gmail account to my
Hi Pearl I'm desperately trying to reconnect my gmail account to my outlook and it's just not working. … read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
969 satisfied customers
I need assistance with getting my Microsoft code. Microsoft
I need assistance with getting my Microsoft code. JA: What application are you using? Customer: Microsoft 10 JA: Have you installed any updates recently? Customer: I do not think so JA: Anything else … read more
Viet - Computer Tech
Viet - Computer Tech
Computer Technican
Bachelor\u0027s Degree
969 satisfied customers
I just collated the chapters for a Research paper, and to
Hi-- I just collated the chapters for a Research paper, and to handle the different pagination requirements, I used sections. My document won't allow me to print selected pages. I'm on MAC El Capitain… read more
Mirza Vaseem
Mirza Vaseem
Bachelor\u0027s Degree
8 satisfied customers
I am having issues with my view in word, it cuts off the
I am having issues with my view in word, it cuts off the top. … read more
Jeevan DSouza
Jeevan DSouza
Professor
PhD
6 satisfied customers
I typed a document and inadvertently hit a key that deleted
I typed a document and inadvertently hit a key that deleted my document. Is it possible to retrieve the deleted info? … read more
Thomas Kline
Thomas Kline
IT support Analyst
Associate of Applied Science
6 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x