| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Comparing columns
I have two columns one contains the mailing address and the other has the
actual address. i want to compare these and if they are the same move the address to another column so I can eliminate the rows where the addresses do not match. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing columns
Col A - address1
ColB - address2 ColC; cell C1 =IF(A1=B1,A1,"") If this post helps click Yes --------------- Jacob Skaria "jv" wrote: I have two columns one contains the mailing address and the other has the actual address. i want to compare these and if they are the same move the address to another column so I can eliminate the rows where the addresses do not match. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing columns
I think that would work if i could also condition on the first 15 charactors
as the mailing addresses have ST, AVe BLVd and the actual addressdoes not "Jacob Skaria" wrote: Col A - address1 ColB - address2 ColC; cell C1 =IF(A1=B1,A1,"") If this post helps click Yes --------------- Jacob Skaria "jv" wrote: I have two columns one contains the mailing address and the other has the actual address. i want to compare these and if they are the same move the address to another column so I can eliminate the rows where the addresses do not match. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing columns
=IF(LEFT(A1,15)=LEFT(B1,15),A1,"")
Difficult to suggest something unless you analyze the data.. If this post helps click Yes --------------- Jacob Skaria "jv" wrote: I think that would work if i could also condition on the first 15 charactors as the mailing addresses have ST, AVe BLVd and the actual addressdoes not "Jacob Skaria" wrote: Col A - address1 ColB - address2 ColC; cell C1 =IF(A1=B1,A1,"") If this post helps click Yes --------------- Jacob Skaria "jv" wrote: I have two columns one contains the mailing address and the other has the actual address. i want to compare these and if they are the same move the address to another column so I can eliminate the rows where the addresses do not match. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing columns
Here is the data for a line in my report
D L C/O P O BOX 33 6063 CARROLL Formula used =IF(LEFT(D764,8)=LEFT(L764,8),D764,"") "Jacob Skaria" wrote: =IF(LEFT(A1,15)=LEFT(B1,15),A1,"") Difficult to suggest something unless you analyze the data.. If this post helps click Yes --------------- Jacob Skaria "jv" wrote: I think that would work if i could also condition on the first 15 charactors as the mailing addresses have ST, AVe BLVd and the actual addressdoes not "Jacob Skaria" wrote: Col A - address1 ColB - address2 ColC; cell C1 =IF(A1=B1,A1,"") If this post helps click Yes --------------- Jacob Skaria "jv" wrote: I have two columns one contains the mailing address and the other has the actual address. i want to compare these and if they are the same move the address to another column so I can eliminate the rows where the addresses do not match. |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Comparing columns
Woops I forgot to say that I got no results in the column where i put the
formula "jv" wrote: Here is the data for a line in my report D L C/O P O BOX 33 6063 CARROLL Formula used =IF(LEFT(D764,8)=LEFT(L764,8),D764,"") "Jacob Skaria" wrote: =IF(LEFT(A1,15)=LEFT(B1,15),A1,"") Difficult to suggest something unless you analyze the data.. If this post helps click Yes --------------- Jacob Skaria "jv" wrote: I think that would work if i could also condition on the first 15 charactors as the mailing addresses have ST, AVe BLVd and the actual addressdoes not "Jacob Skaria" wrote: Col A - address1 ColB - address2 ColC; cell C1 =IF(A1=B1,A1,"") If this post helps click Yes --------------- Jacob Skaria "jv" wrote: I have two columns one contains the mailing address and the other has the actual address. i want to compare these and if they are the same move the address to another column so I can eliminate the rows where the addresses do not match. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| comparing 2 columns | Excel Discussion (Misc queries) | |||
| Comparing to columns | Excel Discussion (Misc queries) | |||
| Comparing two columns of information with 2 new columns of informa | Excel Discussion (Misc queries) | |||
| comparing columns | Excel Worksheet Functions | |||
| Comparing columns | Excel Discussion (Misc queries) | |||
Linear Mode
