MIN MAX Question

[DHayes]

Good day,
I have a question that is got me a bit stymied. What I am doing is find the earliest and the latest date. The MIN formula is done completely different to the MAX formula. What I don't understand is why I cannot use the same formula for both Scenarios. If swap the formula's around I get the incorrect outputs but the two differences work 100% for thier respective outputs.
MIN Formula

{=MIN(INDEX(Contracts!$F$1:$F$10000,MATCH(B2&A2,Contracts!$C$1:$C$10000&Contracts!$E$1:$E$10000,0)))}

MAX fromula

{=MAX(IF((Contracts!$C$1:$C$10000=B2)*(Contracts!$E$1:$E$10000=A2),Contracts!$U$1:$U$10000,0))}

 

[Aladin Akyurek]

Control+shift+enter, not just enter:

=MIN(IF(Contracts!$C$1:$C$10000=B2,IF(Contracts!$E$1:$E$10000=A2,Contracts!$U$1:$U$10000)))

=MAX(IF(Contracts!$C$1:$C$10000=B2,IF(Contracts!$E$1:$E$10000=A2,Contracts!$U$1:$U$10000)))

For faster calculations, use MINIFS and MAXIFS you have them.

 

[DHayes]

Thanks Aladin, it is appreciated.

 

[Aladin Akyurek]

Thanks Aladin, it is appreciated.

You are welcome.