If statement

[Noz2k]

At the moment I have a formula which is

=MAX(IF((LEFT(Wallboard!$A$2:$A$534038,13)) ="Mon Jun 27 10",Wallboard!$E$2:$E$534038),0) - MAX(IF((LEFT(Wallboard!$A$2:$A$534038,13)) ="Mon Jun 27 09",Wallboard!$E$2:$E$534038),0)


What I want to do is replace the "Mon Jun 27 10" part with 2 things.

Instead I would like it to say if Left(ref, 3) = A12 and if Mid(ref,12,2) = D11

and similarly for "Mon Jun 27 09"

I think it should be something like

=MAX(IF((LEFT(Wallboard!$A$2:$A$534038,3))=A12,IF((MID(Wallboard!$A$2:$A$534038,12,2))=D11,Wallboard!$E$2:$E$534038),0)-MAX(IF((LEFT(Wallboard!$A$2:$A$534038,3))=A12,IF((MID(Wallboard!$A$2:$A$534038,12,2))=E11,Wallboard!$E$2:$E$534038),0)))

 

[T. Valko]

At the moment I have a formula which is

=MAX(IF((LEFT(Wallboard!$A$2:$A$534038,13)) ="Mon Jun 27 10",Wallboard!$E$2:$E$534038),0) - MAX(IF((LEFT(Wallboard!$A$2:$A$534038,13)) ="Mon Jun 27 09",Wallboard!$E$2:$E$534038),0)


What I want to do is replace the "Mon Jun 27 10" part with 2 things.

Instead I would like it to say if Left(ref, 3) = A12 and if Mid(ref,12,2) = D11

and similarly for "Mon Jun 27 09"

I think it should be something like

=MAX(IF((LEFT(Wallboard!$A$2:$A$534038,3))=A12,IF((MID(Wallboard!$A$2:$A$534038,12,2))=D11,Wallboard!$E$2:$E$534038),0)-MAX(IF((LEFT(Wallboard!$A$2:$A$534038,3))=A12,IF((MID(Wallboard!$A$2:$A$534038,12,2))=E11,Wallboard!$E$2:$E$534038),0)))

Try this...

Array entered**:

=MAX(IF(LEFT(Wallboard!$A$2:$A$534038,3)=A12,IF(MID(Wallboard!$A$2:$A$534038,12,2)=D11,Wallboard!$E$2:$E$534038)))-MAX(IF(LEFT(Wallboard!$A$2:$A$534038,3)=A12,IF(MID(Wallboard!$A$2:$A$534038,12,2)=E11,Wallboard!$E$2:$E$534038)))

** array formulas need to be entered using the key
combination of CTRL,SHIFT,ENTER (not just ENTER).
Hold down both the CTRL key and the SHIFT key
then hit ENTER.

I imagine that's kind of slow to calculate.