How to Test Terminated Employees
 

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.
--
Fubdap

How to Test Terminated Employees
 

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)

"fubdap" wrote in message
...
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.
--
Fubdap

How to Test Terminated Employees
 

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


"Bob Phillips" wrote:

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)

"fubdap" wrote in message
...
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.
--
Fubdap