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
MAX fromula
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
Code:
{=MIN(INDEX(Contracts!$F$1:$F$10000,MATCH(B2&A2,Contracts!$C$1:$C$10000&Contracts!$E$1:$E$10000,0)))}
Code:
{=MAX(IF((Contracts!$C$1:$C$10000=B2)*(Contracts!$E$1:$E$10000=A2),Contracts!$U$1:$U$10000,0))}