software

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

W. Larson

quot;WLarsonquot; wrote:
gt; I need to remove from one column all entries that appear in another
gt; column, but replace them with quot;-----quot;. 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)),quot;-----quot;,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 gt; values

Adapt to suit ..
--
Max
Singapore
savefile.com/projects/236895
xdemechanik
---