I haven't graduated to pivot tables yet, but it seems like something I should
look into. If it's not too complicated, what steps what I need to do ?
Don's suggestion did work very well.

Thanks again,
Steve

"RichardSchollar" wrote:

Steve

You could use a pivot table for this and under field settings (ie for
your Data field - which would be the time column) select Max.

Richard


Steve wrote:
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