Matching Formula
 

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

Hi Steve,

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

HTH
Regards,
Howard

"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

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

--
Regards
Frank Kabel
Frankfurt, Germany

"Steve H." schrieb im Newsbeitrag
...
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

Thank you both. This is an awsome newsgroup.


"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

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

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

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

Steve


"Frank Kabel" wrote in message
...
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