Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete items in one list from another list?
I have a large mailing list for marketing and I would like to delete existing
clients and their surrounding zip codes. I have a list of their zip codes, is there a way to delete all instances of a zip code on one list from the other. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete items in one list from another list?
ASAP Utilities, a free Add-in available at www.asap-utilities.com has a
feature that does this nicely..... Vaya con Dios, Chuck, CABGx3 "Danielle" wrote in message ... I have a large mailing list for marketing and I would like to delete existing clients and their surrounding zip codes. I have a list of their zip codes, is there a way to delete all instances of a zip code on one list from the other. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete items in one list from another list?
Thank you. Do you know exactly what I need to do.
"CLR" wrote: ASAP Utilities, a free Add-in available at www.asap-utilities.com has a feature that does this nicely..... Vaya con Dios, Chuck, CABGx3 "Danielle" wrote in message ... I have a large mailing list for marketing and I would like to delete existing clients and their surrounding zip codes. I have a list of their zip codes, is there a way to delete all instances of a zip code on one list from the other. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete items in one list from another list?
After downloading and installing the ASAP Utilities Add-in,
Highlight the column that contains the Zip codes Click on ASAP Utilities to produce the drop down menu Select "Columns and Rows" Select "Conditional row and column select, hide or delete" Set "Search Options" to "equal to" Enter the Zip code you wish to delete in the small window Select "Rows" radio button Select "Delete" radio button Click "Start" Click "Close" Vaya con Dios, Chuck, CABGx3 "Danielle" wrote in message ... Thank you. Do you know exactly what I need to do. "CLR" wrote: ASAP Utilities, a free Add-in available at www.asap-utilities.com has a feature that does this nicely..... Vaya con Dios, Chuck, CABGx3 "Danielle" wrote in message ... I have a large mailing list for marketing and I would like to delete existing clients and their surrounding zip codes. I have a list of their zip codes, is there a way to delete all instances of a zip code on one list from the other. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I delete items in one list from another list?
Thanks that was a great help.
"CLR" wrote: After downloading and installing the ASAP Utilities Add-in, Highlight the column that contains the Zip codes Click on ASAP Utilities to produce the drop down menu Select "Columns and Rows" Select "Conditional row and column select, hide or delete" Set "Search Options" to "equal to" Enter the Zip code you wish to delete in the small window Select "Rows" radio button Select "Delete" radio button Click "Start" Click "Close" Vaya con Dios, Chuck, CABGx3 "Danielle" wrote in message ... Thank you. Do you know exactly what I need to do. "CLR" wrote: ASAP Utilities, a free Add-in available at www.asap-utilities.com has a feature that does this nicely..... Vaya con Dios, Chuck, CABGx3 "Danielle" wrote in message ... I have a large mailing list for marketing and I would like to delete existing clients and their surrounding zip codes. I have a list of their zip codes, is there a way to delete all instances of a zip code on one list from the other. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Most popular items in a list | Excel Worksheet Functions | |||
How do I delete the drop down list of header / footer options in e | Excel Discussion (Misc queries) | |||
Checking for duplicate items in list | Excel Worksheet Functions | |||
Compare 2 columns, and create a list of items that are in both lists | Excel Worksheet Functions | |||
copying list items | Excel Discussion (Misc queries) |