May 22 2019 06:33 AM
Hi all,
I have a sheet for my running information - I would like to have it look through all the runs via distance, find 3km and then return the fastest time (or whichever way makes more sense).
I have attached the document - I would like it to find the fastest times (column F) for the 3, 5 and 10 distances under Column E and present the time in its corresponding cell at the top.
Thank you in advanced for all yourself.
May 22 2019 07:00 AM
@Marc Wheeler , that could be like
=AGGREGATE(15,6,1/($E$8:$E$370=$E3)*$F$8:$F$370,1)
Please see in attached
May 22 2019 07:03 AM
@Sergei Baklan Thank you very much for this! Works perfectly?
May 22 2019 08:25 AM
@Marc Wheeler , you are welocme