| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do i omit the a list, and it's matches, so neither exists?
I have a list of mass emails.
I also have a list that i want reps to send out seperatly, so I don't want these in the mass list anymore. How do I have excel locate all these names and delete them. Not just delete duplicates, because that still leaves them in their. I want to show it my list, and have it remove these names from the mass list, so neither exists. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i omit the a list, and it's matches, so neither exists?
Try this sample from my archives* ..
It's tailored for the intents that you seek <g: http://savefile.com/files/103141 Extracting an exclusion list.xls (nicely rendered, full details, easy to understand and adapt) *archives link in sign-off -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "markcjr" wrote: I have a list of mass emails. I also have a list that i want reps to send out seperatly, so I don't want these in the mass list anymore. How do I have excel locate all these names and delete them. Not just delete duplicates, because that still leaves them in their. I want to show it my list, and have it remove these names from the mass list, so neither exists. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i omit the a list, and it's matches, so neither exists?
Hi Mark:
The simple one-off solution is to use vlookup. As in in a new column on the mass list sheet with the name in column a and also on the reps sheet (here called reps) enter: =if(isna(vlookup(a1,reps!a:a,1,false)),"<<<","") that will find all the names that are the same on the reps sheet. you name need to consider using trim and lcase on the names first to reduce typos. -- Hope this helps Martin Fishlock, Bangkok, Thailand Please do not forget to rate this reply. "markcjr" wrote: I have a list of mass emails. I also have a list that i want reps to send out seperatly, so I don't want these in the mass list anymore. How do I have excel locate all these names and delete them. Not just delete duplicates, because that still leaves them in their. I want to show it my list, and have it remove these names from the mass list, so neither exists. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do i omit the a list, and it's matches, so neither exists?
Sorry, the earlier link should have read as:
http://savefile.com/files/103141 Extracting an exclusion list.xls Earlier link pasted carried an unwanted semicolon which I missed cleaning off. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
