Removing all entries in one list that appear in a different list

W

WLarson

Hi. I need to remove from one column all entries that appear in another
column, but replace them with "-----". Thanks alot for your time

W. Larson
 
M

Max

WLarson said:
I need to remove from one column all entries that appear in another
column, but replace them with "-----". Thanks alot for your time
Click to expand...

Here's one try ..

Assume entries in col A is to be compared with those in col B,
data assumed from row1 down

we could put in C1:
=IF(ISNUMBER(MATCH(A1,B:B,0)),"-----",A1)
and copy C1 down till the last row of data in col A

Col C will return thre required results

And if necessary, just copy col C to overwrite col A
with a paste special > values

Adapt to suit ..
 
Top