Thread: [Solved] Comparing 2 columns of Text
View Single Post
 
Old 01-30-2012, 04:28 PM
Berk21 Berk21 is offline Windows XP Office 2010 64bit
Novice
 
Join Date: Jan 2012
Posts: 11
Berk21 is on a distinguished road
Default

Quote:
Originally Posted by Catalin.B View Post
You want to compare the lenght of text in two cells?
Try : =if(len(C2)>len(C1);len(C2)-len(C1);C2&" lenght is not bigger than "&C1&" lenght.")

Not length, but more like 6 words is greater then 5 words.
as if your converting the words to numbers..and adding them and comparing which column came out ahead..if column with "x" > "y" X counts 1 and Y counts 0 in a differnt area (just for example - Cell A1 for x and A2 for Y)
Depending on the word...
Thats why i used "text" & "text2" as my test...if you were to type them 1000x side by side, and happen to miss one of either..this formula would see which one and how many times you miss typed in a cell that totals that ansewr.

Thanks

Last edited by Berk21; 01-30-2012 at 04:38 PM. Reason: typing error
Reply With Quote