How to Test Terminated Employees

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
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)
 
Thanks Bob for your help. It worked.
--
Fubdap


Bob Phillips said:
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)
Click to expand...
 
Back
Top