Thread
:
Using criteria
View Single Post
#
4
Posted to microsoft.public.excel.worksheet.functions
Don Guillett
Posts: n/a
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
Reply With Quote