| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
remove records when fields match in 2 worksheets??
Hi All,
I'm hoping this is and easy one. I have 2 worksheets (sheet1 and sheet2)and want to create a 3rd (sheet 3) based on some filtering using the sheet 1 and sheet2. I want to remove all the records in sheet 1 where the email field matches and email field somewhere in sheet2. If I can just remove them in sheet 1 then I don't need to create sheet3 at all. Can anyone advise how to do this? TIA, Case |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| De-Dupe Records Based on Two Fields. | Excel Discussion (Misc queries) | |||
| Duplicate records with various formats for fields | Excel Discussion (Misc queries) | |||
| Can you match records from two different worksheets | Excel Worksheet Functions | |||
| flip spreadsheet data from row records to column record fields | Excel Discussion (Misc queries) | |||
| flip spreadsheet data from row records to column record fields | Excel Discussion (Misc queries) | |||
Threaded Mode
