Forum Discussion

Marc Wheeler's avatar
Marc Wheeler
Copper Contributor
May 22, 2019

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).

 

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.

 

 

Resources