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

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

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

Using criteria
 

glad to help

--
Don Guillett
SalesAid Software

"Tubthumper" wrote in message
...
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