Forum Discussion
Solved
Simple formula for search the min date with criteria
Hi All, the screenshot are the sample of raw data and result. I would like to return the earliest date from the category of "pull,push,pull-M,push-M" with formula at K column.
Use
=IF(MINIFS($G$111:$G$500, $F$111:$F$500, J111, $H$111:$H500, "pu*")=0,"",MINIFS($G$111:$G$500, $F$111:$F$500, J111, $H$111:$H500, "pu*"))
Thanks for the help on it. My excel is newer version, with Minifs will return 0-Jan-00 if not found or match, I would like to have show blank or empty if not found.
Use
=IF(MINIFS($G$111:$G$500, $F$111:$F$500, J111, $H$111:$H500, "pu*")=0,"",MINIFS($G$111:$G$500, $F$111:$F$500, J111, $H$111:$H500, "pu*"))