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.
For Example for the WO 459822 the last operation should be "20" because is the last operation with 1 for that WO.
I'm using office 2013
Regards
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)))
3 Replies
If as regular formula (without ctrl+shift+enter)
=AGGREGATE(14,6, station/(Closed=1)/(WO=H4),1)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)))
