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