How to Test Terminated Employees

[Guest]

I have 2 spreatsheets. Sheet #1 has the list of current employes with their
names, ids, dept, etc. Sheet #2 has list of terminated employees with their
names, id, date of termination, etc. I want to ensure that there is no
terminated employee on the current employee list (sheet #1). How can I do
that. Any ideas will be appreciated.

Thanks.

 

[Bob Phillips]

Add a formula of

=ISNUMBER(MATCH(A2,Sheet1!A:A,0))

on Sheet 2 in some spare column, then filter for TRUE

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Guest]

Thanks Bob for your help. It worked.
--
Fubdap

Add a formula of

=ISNUMBER(MATCH(A2,Sheet1!A:A,0))

on Sheet 2 in some spare column, then filter for TRUE

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)