Hello ,

I have data something like this, I only need to include all employees who has access to dept 50 and excludes employees who have access to department 100


Employee ID     Line     Department ID
100              1     350
100              2     150
100              3     250
100              4     50
100              5     450
101              1     50
101              2     100
101              3     150
101              4     250


my data looks something like this

100              1     350
100              2     150
100              3     250
100              4     50
100              5     450

101 employee has access to both 100 & 50 so he has to be eliminated.

Thanks !!!


Edited by achandana01 - 08 Feb 2014 at 8:16am