Comparing text strings
On Sat, 28 Nov 2009 13:25:39 -0500, "Rick Rothstein"
wrote:
Maybe this formula?
=AND(LEFT(A1,FIND(" ",A1)-1)=LEFT(B1,FIND("
",B1)-1),TRIM(RIGHT(SUBSTITUTE(A1," ",REPT("
",99)),99))=TRIM(RIGHT(SUBSTITUTE(B1," ",REPT("
",99)),99)),IF(LEN(A1)-LEN(SUBSTITUTE(A1,"
",""))=LEN(B1)-LEN(SUBSTITUTE(B1," ","")),MID(A1,FIND(" ",A1&" ")+1,FIND("
",A1&" ",FIND(" ",A1&" ")+1)-FIND(" ",A1&" ")-1)=MID(B1,FIND(" ",B1&"
")+1,FIND(" ",B1&" ",FIND(" ",B1&" ")+1)-FIND(" ",B1&" ")-1),TRUE))
--
Rick (MVP - Excel)
Maybe, but we don't have enough information yet.
One thought, based on only on looking quickly at your formula, is that it only
compares A1 & B1. My guess would be that we need to compare all of column B
with A1.
--ron
|