Quote:
Originally Posted by Catalin.B
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