Forum Discussion
Formular Help - Search Min Time for Certain Distance and present
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). ...
Marc Wheeler , that could be like
=AGGREGATE(15,6,1/($E$8:$E$370=$E3)*$F$8:$F$370,1)
Please see in attached
SergeiBaklan Thank you very much for this! Works perfectly?
Marc Wheeler , you are welocme