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

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

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

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

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 ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---