Comparing cells with text
=COUNTIF(A1:B1,A1)=2
"Mortir" wrote:
i have the following case:
A B
1 EUR USD
2 EUR EUR
3 EUR CHF
I'd like to compare the two colums and if the two cels in one row
match, i would get a TRUE answer and if not it would be false - as the
following example:
A B C
1 EUR USD FALSE
2 EUR EUR TRUE
3 EUR CHF FALSE
how do I do that?
thanx for your help!
|