Quote:
Originally Posted by Berk21
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...
Thanks
|
I must say that the formula above is not converting words to numbers.. It counts the number of characters that exists in that cell. If the second cell has a bigger number of characters, the formula result is indeed numeric, but that number represents the number of extra characters in second cell, compared to the first cell. (including spaces)
Please clarify exactly what you want, maybe i misunderstood your problem:
you want the two columns to be a perfect match? (then use Match-formula, the result is numeric
, or a simple comparation =IF(D11=E11;"ok";"no"))
You want to compare the number of whole words (not characters separately) between the 2 columns? This can only be done with a macro.