Thread: Max to specific references
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default 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






Reply With QuoteReply With Quote