Matching Formula

[Steve H.]

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

 

[L. Howard Kittle]

Hi Steve,

=A1=B1 in another cell will return TRUE or FALSE.

HTH
Regards,
Howard

 

[Frank Kabel]

Hi
=IF(A1=B1,"Match","No match")

 

[Steve H.]

Thank you both. This is an awsome newsgroup.

 

[Steve H.]

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?

 

[Frank Kabel]

Hi
see:
http://www.cpearson.com/excel/duplicat.htm#ExtractingCommon
and
http://www.cpearson.com/excel/duplicat.htm#InOneNotOther

 

[Steve H.]

Thanks again Frank....worked like a charm.

Steve