Forum Discussion

Copper Contributor

Jun 21, 2021

Excel Formula use to find earliest date

I want to find the earliest date from the category (Pull Requisition, Push Requisition, Push Requisition-M and Pull Requisition-M) from sheet 2. If use MINIFS(Sheet 2!Category,Sheet 2!Material,Sheet1...

excel

SergeiBaklan

Diamond Contributor

Jun 21, 2021

MeiChan1314

That is something like

=MIN(MINIFS(minRange,criteriaRange,{"Cat1","Cat2"}))

MeiChan1314
Copper Contributor
Jun 25, 2021
SergeiBaklan The formula return error or showing too many argument. hmm..not sure where goes wrong. I have screenshot for example and attached the file here.
Basically I want to get the earliest delivery date from category Pull, Push , Push-M that match with the same material code. Would you be able to write the formula in complete again to let me better understand. Appreciated in advance!

MINIFS.xlsx9 KB
- Lorenzo
  Silver Contributor
  Jun 25, 2021
  MeiChan1314
  in B2
  =MINIFS(H$2:H$10, G$2:G$10,A2, I$2:I$10,"<>po memo")
  - MeiChan1314
    Copper Contributor
    Jun 25, 2021
    seem like exclude POmemo, How about if the category do include In-transit, QM lot...so what will be the best formula to exclude those?