Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
My question may be difficult to understand. Here is my situation: I have two
columns (ex: column 1 and column 2). Column 1 has information repeated in column 2. I would like to identify info from column 1 and remove it from column 2. For example Column 1 | Column 2 | American Online | American Online, 1234 USA street | AMD Anthlon | AMD Anthlon, Customer Support | I would like it to identify American Online, and AMD anthlon from Column 1 and remove it from Column 2... Giving me: Column 1 | Column 2 | American Online | 1234 USA street | AMD Anthlon | Customer Support | I would really appreciate if anyone could help me out with this problem. Thank you very much for your time. ~Johnny B |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How do I sort by info in one column and it stay in line with info | Excel Worksheet Functions | |||
Finding/Removing Duplicate Numbers In A Column ? | New Users to Excel | |||
Finding/removing duplicate names in a worksheet | Excel Worksheet Functions | |||
Link info in one cell to info in several cells in another column (like a database) | Excel Discussion (Misc queries) | |||
What Excel Formula = finding dup records and removing them? | Excel Worksheet Functions |