Using criteria

T

Tubthumper

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
 
D

Don Guillett

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

Tubthumper

Nice one!
Thanx


Don Guillett said:
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))
Click to expand...
 
Top