Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting unwanted data
Hi Guys,
I have a situation where a company has had one if its divisions closed and all of their products need to be removed from the product listing in Excel. I need to remove about 150 products from the product listing which has over 2500. Is there some way to compare the two lists and then delete the products from the main list. regards Paul |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting unwanted data
Hi Paul,
How is your data laid out, in a single column or multiple columns? Is there a unique identifier that you can use Autofilter on? A specific letter arrangement in the product code or something similar. Regards Martin |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting unwanted data
Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/duplicat.htm Dono wrote: Hi Guys, I have a situation where a company has had one if its divisions closed and all of their products need to be removed from the product listing in Excel. I need to remove about 150 products from the product listing which has over 2500. Is there some way to compare the two lists and then delete the products from the main list. regards Paul -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Vlookup to Return a Range of Data | Excel Discussion (Misc queries) | |||
Macro question | Excel Worksheet Functions | |||
Inputting data to one worksheet for it effect another | Excel Discussion (Misc queries) | |||
Deleting filtered out data from a worksheet | Excel Worksheet Functions | |||
From several workbooks onto one excel worksheet | Excel Discussion (Misc queries) |