Avatar of Dier Eluom
Dier Eluom asked on

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.
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Rob Henson

8/22/2022 - Mon
ASKER
Dier Eluom

'In an Excel spreadsheet I have a row' should read 'column'.  Early morning fogginess.
Alan

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.
ASKER
Dier Eluom

File uploaded.
example.xlsm
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes
ASKER CERTIFIED SOLUTION
Alan

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
See how we're fighting big data
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER
Dier Eluom

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.
ASKER
Dier Eluom

and 'gender'
ASKER
Dier Eluom

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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
ASKER
Dier Eluom

Thanks  Allan!
Alan

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
ASKER
Dier Eluom

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?
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Alan

Make sure to include the equals sign, but not the curly braces, and enter it with shift-ctrl-enter as an array formula.
Rob Henson

Not really any need for array formulas.

This can be done with a Pivot Table.

See attached.
example.xlsm