Possibly could with MINIFS and MAXIFS but I don't have those functions available in Excel 2010 to test.
=MINIFS($K$9:$K$70, $H$9:$H$70, 1, $J$9:$J$70, "<>000001")
Review https://professor-excel.com/how-to-u...mula-in-excel/
Possibly could with MINIFS and MAXIFS but I don't have those functions available in Excel 2010 to test.
=MINIFS($K$9:$K$70, $H$9:$H$70, 1, $J$9:$J$70, "<>000001")
Review https://professor-excel.com/how-to-u...mula-in-excel/
How to attach file: Reading and Posting Messages (vbaexpress.com), click Go Advanced below post edit window. To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Posting Permissions
Reply With Quote