| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Remove duplicates found in master list
Yup! Perfect! Thanks Otto!
"Otto Moehrbach" wrote: Mike This macro should do what you want. HTH Otto Sub RemoveDups() Dim RngB As Range Dim RngA As Range Dim i As Range Set RngA = Range("A1", Range("A" & Rows.Count).End(xlUp)) Set RngB = Range("B1", Range("B" & Rows.Count).End(xlUp)) For Each i In RngB If Not RngA.Find(What:=i.Value, Lookat:=xlWhole) Is Nothing Then _ i.Delete Shift:=xlUp Next i End Sub "Mike" wrote in message ... Hey guys! I have 2 columns of data. In column A is my master list of names and in column B is a list of names that I would like to compare against my master list in column A. If the name is found in column B that exists in column A, remove the name from column B. Can this done in excel? Thanks!! Mike |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Remove Duplicates; How can I get a list of items removed? | Excel Discussion (Misc queries) | |||
| how to remove duplicates ONLY within the same category | Excel Discussion (Misc queries) | |||
| Remove duplicates | Excel Discussion (Misc queries) | |||
| compare two columns and remove duplicates | Excel Worksheet Functions | |||
| How to remove duplicates from a list and copy new list to new colu | Excel Worksheet Functions | |||
Hybrid Mode
