Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using criteria
I have a keen cyclist and I input all the data from my cycle computer into
excel (time taken, distance travelled, max speed, average speed, etc). I generally cycle one of 3 routes (Loop 1, Loop 2 and Loop 3), and state this in a column next to the numerical data. Is there a way of finding my fastest time from from Loop 1? Or the shortest time taken on Loop 2? I'm sure there is - but I haven't found it! Many thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using criteria
This is an array formula that must be created/edited with ctrl+shift+enter
vs just enter. =MIN(IF((E1:E10="Loop 1"),F1:F10)) -- Don Guillett SalesAid Software "Tubthumper" wrote in message ... I have a keen cyclist and I input all the data from my cycle computer into excel (time taken, distance travelled, max speed, average speed, etc). I generally cycle one of 3 routes (Loop 1, Loop 2 and Loop 3), and state this in a column next to the numerical data. Is there a way of finding my fastest time from from Loop 1? Or the shortest time taken on Loop 2? I'm sure there is - but I haven't found it! Many thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using criteria
Nice one!
Thanx "Don Guillett" wrote: This is an array formula that must be created/edited with ctrl+shift+enter vs just enter. =MIN(IF((E1:E10="Loop 1"),F1:F10)) -- Don Guillett SalesAid Software "Tubthumper" wrote in message ... I have a keen cyclist and I input all the data from my cycle computer into excel (time taken, distance travelled, max speed, average speed, etc). I generally cycle one of 3 routes (Loop 1, Loop 2 and Loop 3), and state this in a column next to the numerical data. Is there a way of finding my fastest time from from Loop 1? Or the shortest time taken on Loop 2? I'm sure there is - but I haven't found it! Many thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DAVERAGE criteria HELP!!!! | Excel Discussion (Misc queries) | |||
Returning Results Based on Two Criteria | Excel Worksheet Functions | |||
Find largest alphanumeric value matching alpha criteria in databas | Excel Worksheet Functions | |||
sorting more than 3 keys | Excel Discussion (Misc queries) | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions |