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?

 

[Aladin Akyurek]

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?

Control+shift+enter, not just enter:

=IFERROR(SMALL(IF((A2:A100="a")+(B2:B100="x"),C2:C100),1),"N/A")