I am trying to delete rows that have Observation or Fail containted in column B and any row with the Emp in column C that had an Observation or Fail in column B.
Example:
B C
Pass 1111
Fail 1111
Observation 2222
Pass 3333
Observation 3333
Pass 3333
Pass 4444
Pass 4444
Fail 3333
Pass 5555
The result would have just the rows left with Emp 4444 and 5555 left on the sheet.
Thanks for your time.
Bookmarks