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.
|