Aug 09 2021 11:48 PM
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.
Aug 10 2021 12:37 AM
If you have Excel 2019 or Excel in Microsoft 365, enter the following formula in K111:
=MINIFS($G$111:$G$500, $F$111:$F$500, J111, $H$111:$H500, "pu*")
Adjust the ranges if your data extend below row 500, then fill down.
If you have an older version of Excel, enter the following formula in K111 and confirm it with Ctrl+Shift+Enter to turn it into an array formula:
=MIN(IF(($F$111:$F$500=J111)*(LEFT($H$111:$H500, 2)="pu"), $G$111:$G$500))
and fill down.
Aug 10 2021 05:12 AM
Aug 10 2021 05:19 AM
SolutionUse
=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*"))
Aug 10 2021 05:19 AM
SolutionUse
=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*"))