Max to specific references
 

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

Max to specific references
 

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

Max to specific references
 

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

Max to specific references
 

Perfect. And so simple.

Thanks much,
Steve

"Don Guillett" wrote:

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

Max to specific references
 

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

Max to specific references
 

Glad to help.

--
Don Guillett
SalesAid Software

"Steve" wrote in message
...
Perfect. And so simple.

Thanks much,
Steve

"Don Guillett" wrote:

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