
Attached is a sample workbook. What I am trying to see if the next Op Sequence that is still open (status: O), only if it has specific centers (only OV, SUBCON, and JSPL)
Is there any way to set up a filter to narrow it down like that?
11 answers

I think I figured it out. I made a T/F if it meets the criteria for the False/True of the two filters above, and then did a fixed LOD for the min result of that.
Thanks for the help getting me in the right direction!