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
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 |
Bookmarks