Compare Two Cells
You might try this formula:
=IF(A1=B1,"match","mismatch")
....then copy and paste that formula over the rest of the range.
The English translation is: Compare the entry in A1 to the entry in
B1. If the match, return the word "match". If they do not match,
return the word "mismatch".
Dave O
Eschew obfuscation
|