Excel: Remove data from a column that appears in another one
Solved
Gasp227
-
Gasp227 -
Gasp227 -
Hello,
I’d like to know if you can help me with Excel. Here is my problem:
In a table, I have two columns: Column B "full list" where, row by row, 1000 email addresses appear, and Column C "invalid addresses" where, row by row, about 100 addresses appear that all appear once in column B. They are essentially a subset of column B.
I’d like to remove from column B all addresses that are in column C, since they are no longer valid.
Do you know if there is a quick formula to do this, rather than searching for and deleting each value separately?
Thanks in advance for your responses!
Gaspard
I’d like to know if you can help me with Excel. Here is my problem:
In a table, I have two columns: Column B "full list" where, row by row, 1000 email addresses appear, and Column C "invalid addresses" where, row by row, about 100 addresses appear that all appear once in column B. They are essentially a subset of column B.
I’d like to remove from column B all addresses that are in column C, since they are no longer valid.
Do you know if there is a quick formula to do this, rather than searching for and deleting each value separately?
Thanks in advance for your responses!
Gaspard
2 answers
-
Hello
to avoid going to VBA:
in a column or elsewhere:
start at D2 and for the entire height
=IF(COUNTIF($C:$C;B2);"";B2)
you will have in D a list of addresses to keep
copy there, column D
paste special "values" on B (or elsewhere and even possibly on D)
then "sort" or "remove duplicates to compact the gap-filled list" obtained
crdlmnt
--
Errare humanum est, perseverare diabolicum -
