MIN IF for multiple criteria in the same column

[xrajncajnx]

I have a column of test results with a test status and date for each test. What I'm looking for is a MIN IF formula that will give me the earliest "start date" only if the status is either "SAT" or "PART." In the small example below, the date returned would be "03/05/19." I can handle the MIN IF formula,
ex

Please Login or Register  to view this content.

My problem comes with trying to introduce the OR "PART" statement that's throwing me for a loop.

TEST	RESULT	DATE
test1	SAT	05/08/19
test2	REJ	01/05/19
test3	PART	03/05/19
test4	CHG	04/02/19
test5	PART	04/02/19
test6	SAT	03/19/19
test7	REJ	02/02/19
test8	SAT	04/08/19

[José Augusto]

HI

If your data is in B3:C10 (row 2 has headers) use the following formula

Please Login or Register  to view this content.

[Phuocam]

Try

{= MIN(IF((B2:B8="SAT")+(B2:B8="PART"),C2:C8))}

[xrajncajnx]

HI

If your data is in B3:C10 (row 2 has headers) use the following formula

Please Login or Register  to view this content.

Thank you, but that returns the 03/19/19 date for test6 which was "SAT", not the 03/05/19 date that is needed. The formula still excludes the results that were coded as "PART."

[xrajncajnx]

Try

{= MIN(IF((B2:B8="SAT")+(B2:B8="PART"),C2:C8))}

That did it perfectly, thank you.

[José Augusto]

Hi

To correct my formula in post #2 (I forgot the "OR")

Please Login or Register  to view this content.