CODEWITHSUNDEEP
excelexcel-formula
Lorenzo
Lorenzo

Reputation: 891

MIN IF with multiple criteria Excel (Return earliest date if)

I've used the (hacked) MAX IF function before, so I am not sure why my MIN IF here isn't working (and yes I am array-entering). Doubt that would be the issue, but I'm using Excel on a virtual box (Windows Excel on a Mac).

I determined that the formula was breaking in the IF function. As you can see, it is returning 0, or FALSE, so when I wrap it in the MIN formula it is just giving me an issue. The desired result here should be 6/11/2014.

Example

Upvotes: 2

Views: 52376

Answers (2)

Ron Rosenfeld
Ron Rosenfeld

Reputation: 60289

Showing your formula working with your data:

enter image description here

Upvotes: 3

sudhi
sudhi

Reputation: 115

Try this formula in H7:

=INDEX(B2:B5,MATCH(1,IF(C2:C5=G7,IF(D2:D5>0,1)),0))

confirm with Ctrl+Shift+Enter.

Upvotes: 2

Related Questions