using dates with a MAX

[JakeMann]

Hi,

On sheet 3 of the atatched I am using the following in O10 to get a maximum figure.

=MAX(IF($C$9:$C$12=L10,$G$9:$G$12))

i want to incorporate H9:H12 as well, so for example if a Tool runs into the following day it takes that into account when return the maximum staff.

Is there an easy way of slippingh the H9:H12 into this formula?

Thanks

[wfm007]

Hi Jake,

Formula entered by u is correct, what all u need to do is close this formula as an array(CTRL+SHIFT+ENTER)

[zbor]

Do you mean this:

Please Login or Register  to view this content.

comfirmed with ctrl+shift+enter

[wfm007]

Mean to say

=MAX(IF($C$10:$C$12=L10,$G$10:$G$12,IF($H$10:$H$12=L10,$G$10:$G$12)))

with CTRL+SHIFT+ENTER

[JakeMann]

Yeah, that's what I need.

I forgot about the array bit again.

Thank you

[wfm007]

You r welcome Jay.


Don't forget to click on * button