Urgent Help

[Hussein982]

Hello All: 

There are two excel files containing employee numbers. 

The first excel file contains 3000 employees number.

The second excel file contains 1200 employees number (please note that these 1200 employees are already in my first file), and I need to remove them for a specific reason.

In order to remove the 1200 employees from the original file/first file, what should I do? 

Appreciate your help.

Cheers,

H

[Luke_C · Accepted solution]

Hi @Hussein982 

Join on employee number. The J output will be the 1200 you want to exclude, the L or R output (whichever you connect the 3000 to) will be the remainder.

[Hussein982]

Thank you @Luke_C