Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Duplicated Data by Cell
I have two columns, each column contains email addresses. Column A is the
master list with about 26k entries and Column B is the comparison list with about 19k entries. I would like to delete any Cell in column A that has the same address as ANY cell in Column B. I have tried using the delete duplicate values tool in Excel and for some reason it doesn't work. I am not able to use the method of creating a Unique list of values as I do not want any values from Column B ending up in my master list. I have tried Conditional Formatting then Deleting by format via VB but conditional formatting doesn't really alter the actual format of the cell or font. I have found several potential examples of how this might be accomplished but none of them have been successful. I am able to use any solution whether formula or macro based. Thanks in advance for your time in solving this puzzle. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Duplicated Data by Cell
On Jan 26, 12:50*pm, Fleone wrote:
I have two columns, each column contains email addresses. Column A is the master list with about 26k entries and Column B is the comparison list with about 19k entries. I would like to delete any Cell in column A that has the same address as ANY cell in Column B. I have tried using the delete duplicate values tool in Excel and for some reason it doesn't work. I am not able to use the method of creating a Unique list of values as I do not want any values from Column B ending up in my master list. I have tried Conditional Formatting then Deleting by format via VB but conditional formatting doesn't really alter the actual format of the cell or font. I have found several potential examples of how this might be accomplished but none of them have been successful. I am able to use any solution whether formula or macro based. Thanks in advance for your time in solving this puzzle. A simple VLOOKUP between your two list will do the trick. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Deleting Duplicated Data by Cell
With helper column C...
In C2, put this formula: =ISNUMBER(MATCH(A2,B:B,0)) Copy down as far as needed (to match list A). Autofilter helper column to find "TRUE" values. Select cells A2:A65536 (or however long is needed). Now, press Alt+; to only select the visible cells. Remove the AutoFilter so that we can delete single cells. Now, with the all those unwanted cells still selected, press Ctrl+- (the minus symbol). This will bring up the "Delete" dialogue and you can choose to delete only those specific cells. -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "Fleone" wrote: I have two columns, each column contains email addresses. Column A is the master list with about 26k entries and Column B is the comparison list with about 19k entries. I would like to delete any Cell in column A that has the same address as ANY cell in Column B. I have tried using the delete duplicate values tool in Excel and for some reason it doesn't work. I am not able to use the method of creating a Unique list of values as I do not want any values from Column B ending up in my master list. I have tried Conditional Formatting then Deleting by format via VB but conditional formatting doesn't really alter the actual format of the cell or font. I have found several potential examples of how this might be accomplished but none of them have been successful. I am able to use any solution whether formula or macro based. Thanks in advance for your time in solving this puzzle. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
HOW DO I CROSS OUT DATA IN A CELL WITHOUT DELETING IT? | Excel Worksheet Functions | |||
Deleting Rows with data duplicated in 2 columns | Excel Worksheet Functions | |||
Deleting cell data without deleting formula | Excel Discussion (Misc queries) | |||
can a cell value to be duplicated to another cell during data entr | Excel Worksheet Functions | |||
deleting duplicated cells in a list via advanced autofilter? | Excel Discussion (Misc queries) |