Hi
see:
http://www.cpearson.com/excel/duplic...tractingCommon
and
http://www.cpearson.com/excel/duplic...#InOneNotOther

--
Regards
Frank Kabel
Frankfurt, Germany

"Steve H." schrieb im Newsbeitrag
...
Let me take this a step further.

I have 2 columns of about 2000 rows each. In each column are account
codes
from my chart of accounts for year 2001 and year 2004. I am trying to
compare the two columns to see what accounts have been added and
deleted.

The =A1=B1 only tells me there is no match in the corresponding cell
of each
column. I want to know if there is a match out of any of the 2000
entries in
the corresponding column.


Is there an easier way to do this?


"Steve H." wrote in message
...
If I have text in cell A1 as such 4120-1140 and I want to
compare it
to text in cell B1 to see if it is identical, what would my formula
be.

Thanks.

Steve