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?
  - SergeiBaklan
    Diamond Contributor
    Jun 25, 2021
    MeiChan1314
    
    If you are on 365 you may FILTER() dates first and MIN() result.