Finding best race times in Excel

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

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.

File uploaded.
example.xlsm

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.

and 'gender'

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.

Thanks  Allan!

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

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?

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

Not really any need for array formulas.

This can be done with a Pivot Table.

See attached.
example.xlsm