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)))
If as regular formula (without ctrl+shift+enter)
=AGGREGATE(14,6, station/(Closed=1)/(WO=H4),1)