I'm having trouble figuring out an equation to find data that is dependent on two different criteria. I need to find the equipment #'s that have two different entries that are both 'opened' and 'closed'.



My equipment is in column E and my open/closed is in column S.

I have no idea what I am doing. -_-

Hi
if you post a sample sheet showing data and expected answers it will be easier to help

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

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.

Please post a sheet, the layout might be important. Thx

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post