Max If???

[Denise]

Hello,

I got a response yesterday to a question about the "MAX"
function. My question was can I use Max like "sumif". I
would like to know what the MAX time is but just for
Denise. Is there a function in Excel that can do this?


Time Name
2:00:00 Denise
3:56:00 Steph
12:52:00 Pierre
7:27:00 Karine
1:25:00 Denise
1:14:00 Steph
1:02:00 Pierre
21:28:00 Karine
2:14:00 Denise

This was a formula I recieved yesterday but returns a
Value error. =MAX(IF((B2:B25="Denise"),A2:A25))

Any ideas?

 

[tjtjjtjt]

I think it's an array formula--instead of just pressing enter to accept the formula, you need to press Ctrl Shift Enter. The formula will look like: =MAX(IF{((B2:B25="Denise"),A2:A25))}

You will need to format the cell the formula is in with a Time Format.

tj

 

[Harlan Grove]

...
...

This was a formula I recieved yesterday but returns a
Value error. =MAX(IF((B2:B25="Denise"),A2:A25))

Any ideas?

Well, I'm confused. It appears you liked this response.

Thank you....!!!!Perfect works great.

Denise

If you're getting a #VALUE! error, then very likely you didn't enter the formula
as an array formula. You need to hold down [Ctrl] and [Shift] keys before
pressing [Enter].

 

[Guest]

sorry...

The first time I tried it I think I used Ctrl+shift+enter
but then going back to it this morning I couldn't get it
to work....I am (was)unfamiliar with array formulas. I'll
pay more attention next time.

Denise

-----Original Message-----
...
...

This was a formula I recieved yesterday but returns a
Value error. =MAX(IF((B2:B25="Denise"),A2:A25))

Any ideas?

Well, I'm confused. It appears you liked this response.

Thank you....!!!!Perfect works great.

Denise

If you're getting a #VALUE! error, then very likely you didn't enter the formula
as an array formula. You need to hold down [Ctrl] and [Shift] keys before
pressing [Enter].