Comparing 2 columns of Text
Im trying to compare 2 colums of text and if one comlumn is typed more than the other column, it will sum in cell A1
for instance:
the word Text is typed in C1:C6, and C12:C14
they word Text2 is typed in C7:C11
Obviously Text is typed more than Text2, so cell A1 will count as a "1"
Thanks!
|