Forum Discussion
Solved
Found the last operation
Hello, Could you help me with this? I need a formula that looks for the WO then looks for the largest station that has a "1" in the closed column and the result should be that largest station...
This will do it.
Press ctrl+shift+enter to define formula as an array in Excel 2013:
=MAX(IF(WO=H4,IF(Closed=1,station)))
This will do it.
Press ctrl+shift+enter to define formula as an array in Excel 2013:
=MAX(IF(WO=H4,IF(Closed=1,station)))