An array formula that must be entered using ctrl+shift+enter
=MAX(IF(e2:e14=101,j2:j14))



--
Don Guillett
SalesAid Software

"Steve" wrote in message
...
I have identifiers in the E column(101, 102, etc), and corresponding time
values in the J column.
I need a formula in another cell that would give me the maximum time value
of all the 101's, resuling in (0:17)
And also in another cell the maximum value (0:43) of all the 102's.

E col J col
101 0:00
101
101 0:17
101
102 0:11
102 0:00
102 0:01
102
102 0:43
102 0:00
102 0:01
102 0:03
102 0:00

Thanks,
Steve