I need to compare two strings in excel and determine if they are equal, the strings are in adjacent cells. For example, given:
apple apple
water water
pear carrot
apple water
dog dog
pear carrot
Apple apple
the formula on the third column should give me:
true
true
false
false
true
false
false
Any help appreciated, Ted