I have created a Excel table with Date, Miles Run, Min/Mile time (See attachment). I have built formulas to give me the fastest/slowest Min/Mile time along with the corresponding date and run distance. How do I restrict/modify the formulas to only capture the date and fastest/slowest time specifically for 6.5 mile runs? Thanks!
Try these array formulas and remember to confirm them with Ctrl+Shift+Enter
For fastest record......
Date:Time:
=INDEX($A$5:$A$16,MATCH(MIN(IF($B$5:$B$16=6.5,$C$5:$C$16)),$C$5:$C$16,0))For slowest record....=MIN(IF($B$5:$B$16=6.5,C5:C16))
Date:Time:=INDEX($A$5:$A$16,MATCH(MAX(IF($B$5:$B$16=6.5,$C$5:$C$16)),$C$5:$C$16,0))=MAX(IF($B$5:$B$16=6.5,$C$5:$C$16))
Regards
sktneer
Treat people the way you want to be treated. Talk to people the way you want to be talked to.
Respect is earned NOT given.
Perfect!!! Many thanks!
Glad to help you. Thanks for the feedback.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks