Home

Formular Help - Search Min Time for Certain Distance and present

%3CLINGO-SUB%20id%3D%22lingo-sub-633302%22%20slang%3D%22en-US%22%3EFormular%20Help%20-%20Search%20Min%20Time%20for%20Certain%20Distance%20and%20present%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633302%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20all%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20a%20sheet%20for%20my%20running%20information%20-%20I%20would%20like%20to%20have%20it%20look%20through%20all%20the%20runs%20via%20distance%2C%20find%203km%20and%20then%20return%20the%20fastest%20time%20(or%20whichever%20way%20makes%20more%20sense).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20have%20attached%20the%20document%20-%20I%20would%20like%20it%20to%20find%20the%20fastest%20times%20(column%20F)%26nbsp%3Bfor%20the%203%2C%205%20and%2010%20distances%20under%20Column%20E%20and%20present%20the%20time%20in%20its%20corresponding%20cell%20at%20the%20top.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EThank%20you%20in%20advanced%20for%20all%20yourself.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-633302%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-633399%22%20slang%3D%22en-US%22%3ERe%3A%20Formular%20Help%20-%20Search%20Min%20Time%20for%20Certain%20Distance%20and%20present%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633399%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F167843%22%20target%3D%22_blank%22%3E%40Marc%20Wheeler%3C%2FA%3E%26nbsp%3B%2C%20that%20could%20be%20like%3C%2FP%3E%0A%3CPRE%3E%3DAGGREGATE(15%2C6%2C1%2F(%24E%248%3A%24E%24370%3D%24E3)*%24F%248%3A%24F%24370%2C1)%3C%2FPRE%3E%0A%3CP%3EPlease%20see%20in%20attached%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-633428%22%20slang%3D%22en-US%22%3ERe%3A%20Formular%20Help%20-%20Search%20Min%20Time%20for%20Certain%20Distance%20and%20present%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633428%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F521%22%20target%3D%22_blank%22%3E%40Sergei%20Baklan%3C%2FA%3E%26nbsp%3BThank%20you%20very%20much%20for%20this!%20Works%20perfectly%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-633663%22%20slang%3D%22en-US%22%3ERe%3A%20Formular%20Help%20-%20Search%20Min%20Time%20for%20Certain%20Distance%20and%20present%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-633663%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F167843%22%20target%3D%22_blank%22%3E%40Marc%20Wheeler%3C%2FA%3E%26nbsp%3B%2C%20you%20are%20welocme%3C%2FP%3E%3C%2FLINGO-BODY%3E
Marc Wheeler
Occasional Contributor

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.

 

 

3 Replies

@Marc Wheeler , that could be like

=AGGREGATE(15,6,1/($E$8:$E$370=$E3)*$F$8:$F$370,1)

Please see in attached

 

@Sergei Baklan Thank you very much for this! Works perfectly?

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
202 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies