compare columns and rows

[jv]

I have mailing address in column a and actura address in column b I want to
compare a1 to b1, a2 to b2, and etc. I would need to condition it on the
first 8 or 9 characters as the mailing address has ST< AVE< BLVD etc and the
actual does not.

If they match I want to move the info from A to a new column If they do not
match I wnat the new column row to be blank

 

[Dave Peterson]

Maybe...

=if(left(a1,8)=left(b1,8),a1,"")

I have mailing address in column a and actura address in column b I want to
compare a1 to b1, a2 to b2, and etc. I would need to condition it on the
first 8 or 9 characters as the mailing address has ST< AVE< BLVD etc and the
actual does not.

If they match I want to move the info from A to a new column If they do not
match I wnat the new column row to be blank

 

[jv]

Column D Column L Coulmn O
6111 CARROLL RD 6111 CARROLL
5966 CARROLL RD 5964 CARROLL
C/O P O BOX 33 6063 CARROLL
3 & 4 INC 6185 CARROLL

=IF(LEFT(D763,8)=LEFT(L763,8),D763,"")

Every row is returning blank

 

[Dave Peterson]

First, make sure you're in Automatic calculation mode.
In xl2003 menus:
tools|options|calculation tab.

If that doesn't help, then that means that the first 8 characters in the cells
doesn't match.

Maybe you have leading spaces in either (or both) of the cells:

=IF(trim(LEFT(D763,8))=trim(LEFT(L763,8)),D763,"")

 

[jv]

Dave thani you soooooo much. you saved me hours of work!!!