MIN based upon multiple OR Criteria

[sbsweb]

I would like to find the MIN date in Column C if EITHER col A="a" OR col B="x"

COL A COL B COL C
A Y 12/12/2014
Q X 10/11/2014
B Z 10/10/2014

In this case, the MIN date would be 10/11/2014 because row 1 and 2 meet my "or" criteria, and row 2 date is the MIN date. Can anyone help me with a formula?

 

[XOR LX]

Hi.

Try this array formula**:

=MIN(IF(A1:B3={"A","X"},C1:C3))

Regards