| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Compare 2 columns and delete duplicate text
I need to compare a column of 50,000 terms against a column of the 50 states
to remove any state names from the terms. Is this a formula or macros? How would it be accomplished? Ex. Terms: Furniture Chairs Idaho Desks Desks in Alabama Waterbeds Florida Waterbed Store State list (to remove): Alabama Arizona Arkansas.... |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Compare 2 columns and delete duplicate text
Hi,
See CPearson Web look for Delete duplicate rows, passing the middle of the page http://www.cpearson.com/excel/deleting.htm "MF" wrote: I need to compare a column of 50,000 terms against a column of the 50 states to remove any state names from the terms. Is this a formula or macros? How would it be accomplished? Ex. Terms: Furniture Chairs Idaho Desks Desks in Alabama Waterbeds Florida Waterbed Store State list (to remove): Alabama Arizona Arkansas.... |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Delete BOTH sets duplicate data in columns (debits/credits) | Excel Worksheet Functions | |||
| how do i compare two text columns | Excel Worksheet Functions | |||
| delete duplicate then combine text | Excel Discussion (Misc queries) | |||
| Compare Rows and delete duplicate records | Excel Worksheet Functions | |||
| Compare and delete duplicate records | Excel Worksheet Functions | |||
Linear Mode
