| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extract Rows Unique to Two Sheets
I have 2 spreadsheets with matching column headings. Each sheet has mutiple
rows that must be kept together. I need to find the rows where the value in the first column is unique to both sheets. The uniqueness must only be between the 2 sheets not within each sheet. Here's an example... SHEET #1: ID Last Name First Name Product BKGN5040 Jones Tom HM BKGN5040 Jones Tom UO CAV29010 Smith Kris OC DG742010 Lawson Sue MC EPC47010 Crowley Frank UO SHEET #2: ID Last Name First Name Product GZMPM020 King Carol MC JWSJ9020 White Robert MC LSVKV010 Aronson John UO LSVKV010 Aronson John OC CAV29010 Smith Kris OC LVVVJ020 Sibley Patty HM BKGN5040 Jones Tom HM FILTERED SHEET: ID Last Name First Name Product DG742010 Lawson Sue MC EPC47010 Crowley Frank UO GZMPM020 King Carol MC JWSJ9020 White Robert MC LSVKV010 Aronson John UO LSVKV010 Aronson John OC LVVVJ020 Sibley Patty HM I did a search on this site but couldn't find anything for this type of situation. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Links between sheets in error due to insert rows | Excel Discussion (Misc queries) | |||
| Search a worksheet, extract rows using a list from another sheet | Excel Discussion (Misc queries) | |||
| Transpose unique values in one column/mult. rows into a single row | Excel Worksheet Functions | |||
| extract data from a range of cells in rows or columns when a date. | Excel Worksheet Functions | |||
| Adding Rows to Master Sheet | New Users to Excel | |||
Threaded Mode
