Thread: Figuring out an equation that has two different criteria
View Single Post
 
Old 10-05-2016, 10:29 AM
Lawryr Lawryr is offline Windows 8 Office 2016
Novice
  
Join Date: Oct 2016
Posts: 2
Lawryr is on a distinguished road
Default
EQ006824 CLOSED EQ006826 OPEN EQ006826 CLOSED EQ006827 OPEN EQ006827 OPEN EQ006828 OPEN EQ006828 OPEN EQ006829 OPEN EQ006829 OPEN EQ006830 OPEN EQ006830 OPEN

I need to make sure that all closed equipment numbers also have an open equipment number that matches. So, EQ006826 it perfect because it has an open and a close. However, EQ006824 needs to be flagged because it doesn't also have an open.
Reply With Quote