Forum Discussion
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...
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?
If you are on 365 you may FILTER() dates first and MIN() result.