| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Compare multiple rows for duplicated values in individual columns | Excel Worksheet Functions | |||
| How do I compare rows where there are 30+ columns | Excel Worksheet Functions | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| Excel 2003 - change columns to rows and rows to columns | Excel Discussion (Misc queries) | |||
| Macro to align and compare multiple rows and columns | New Users to Excel | |||
Linear Mode
