Download Files:
[ Ссылка ]

See Mr Excel and excelisfun find the record with the earliest date given three criteria. See Filter and Sort, an array formula that uses the MIN and IF functions, Advanced Filter and the best solution amongst them all the DMIN function.!
Find Earliest Date From List Of Dates Given 2 Criteria Filter or Formula

свернуть