| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Extracting data
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 -- edmacd ------------------------------------------------------------------------ edmacd's Profile: http://www.excelforum.com/member.php...o&userid=27680 View this thread: http://www.excelforum.com/showthread...hreadid=471947 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Printing data validation scenarios | Excel Worksheet Functions | |||
| How do I compare 2 sets of data and highlight differences? | Excel Worksheet Functions | |||
| Sort pages? | Excel Discussion (Misc queries) | |||
| Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) | |||
Threaded Mode
