Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
#6
|
|||
|
|||
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 |
#7
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
revert formula insertion to old method | Setting up and Configuration of Excel | |||
Formula for Searching & matching two values in excel | Excel Discussion (Misc queries) | |||
Matching formula - i need help | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions | |||
matching data formula? | Excel Worksheet Functions |