Finding best race times in Excel

In an Excel spreadsheet I have a row of competitor names and several other columns inc. gender, team and age.  I want to pull out the competitors and three fastest times in minutes: seconds for each age.
Dier EluomAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Dier EluomAuthor Commented:
'In an Excel spreadsheet I have a row' should read 'column'.  Early morning fogginess.
0
AlanConsultantCommented:
Hi Dier,

Without the race times in the spreadsheet, there is no way to do that (none of the columns you say you have, include times, but maybe you omitted?).

Best to post a sample of your file so that we can see what you mean.

Thanks,

Alan.
0
Dier EluomAuthor Commented:
File uploaded.
example.xlsm
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

AlanConsultantCommented:
Hi,

See attached solution.

Thanks,

Alan.
EE-29070379-example-Version1.xlsm
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Dier EluomAuthor Commented:
That is on the right track but it doesn't account for the age of the competitor and doesn't show the times.  In other words 'Competitor' who is 'age' with 'lowest time' - but the three lowest so first, Second and Third.
0
Dier EluomAuthor Commented:
and 'gender'
0
Dier EluomAuthor Commented:
Next to the names I could use =SUMIF(A:A,I2,F:F) to get the times along with the names I suppose?  However, if all same age and gender for a race then it shouldnt be a problem so we can eliminate both.  Then your solution and mine will work.
0
Dier EluomAuthor Commented:
Thanks  Allan!
0
AlanConsultantCommented:
Hi Dier,

Thanks for closing with my solution above as the answer, but I wonder if the attached would be better?

Put the heading (row 1) in as:  M or F followed by {Space}{Dash}{Space} then their age.

Alan.
EE-29070379-example-Version2.xlsm
0
Dier EluomAuthor Commented:
When I copy and paste this into a cell it makes the cell very large and you can see the code?  It also doesn't work - but it works in yours so what am I doing wrong?
0
AlanConsultantCommented:
Make sure to include the equals sign, but not the curly braces, and enter it with shift-ctrl-enter as an array formula.
0
Rob HensonFinance AnalystCommented:
Not really any need for array formulas.

This can be done with a Pivot Table.

See attached.
example.xlsm
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.