compare columns and rows
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 |
compare columns and rows
Maybe...
=if(left(a1,8)=left(b1,8),a1,"") jv wrote: 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 |
compare columns and rows
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" wrote: Maybe... =if(left(a1,8)=left(b1,8),a1,"") jv wrote: 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 |
compare columns and rows
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 wrote: 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" wrote: Maybe... =if(left(a1,8)=left(b1,8),a1,"") jv wrote: 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 -- Dave Peterson |
compare columns and rows
Dave thani you soooooo much. you saved me hours of work!!!
"Dave Peterson" wrote: 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 wrote: 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" wrote: Maybe... =if(left(a1,8)=left(b1,8),a1,"") jv wrote: 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 -- Dave Peterson |
All times are GMT +1. The time now is 04:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com