Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
filtering out records from one worksheet by comparing a field in it with a field in another worksheet
Hi All,
I'm hoping this is an 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to use a field link to rename a worksheet ? | Excel Worksheet Functions | |||
Linked date field in worksheet defaults a blank field as 1/0/1900 | Excel Worksheet Functions | |||
Field and Worksheet Restrictions | Excel Discussion (Misc queries) | |||
can i insert the name of the worksheet into a field? | Excel Discussion (Misc queries) | |||
Field , Date range and Sum from worksheet import | New Users to Excel |