Extracting data

[edmacd]

Good Afternoon Everyone!

I could really use some help with a situation involving data
extraction...

I have two worksheets of data in one workbook. One of the worksheets
is a master list of employees. The second worksheet is only of those
employees who DO meet particular criteria.

What I am trying to do is use those two lists to create a third
worksheet that contains the names of the employees who DO NOT meet the
criteria specified in worksheet #2. In other words extract the names
from worksheet #1 that are not also in worksheet #2.

Does that make sense? Can anyone help?

Thanks!
-Ed

 

[Dave Peterson]

One way...

Say your two worksheets are named Master and Matching.

Insert a new column in the master worksheet.
use a formula like:

=isnumber(match(a1,'matching'!a:a,0))

With the name in A1 and the list of names in column A of Matching.

Drag this formula down.

Apply data|filter|autofilter to that column.

Then filter to show False--copy those visible rows to the third sheet.

===
I think I'd keep the data in Master and just filter to show either the matches
or the mismatches. As soon as I start separating data into different sheets, my
data gets out of sync.

 

[edmacd]

Thank you!

I like your last idea the best, of just keeping everything on on
worksheet. I'm going to play around with that idea more. Thanks fo
such a quick response!

-E