Test if at least two colomns are equal in a range of columns.

Hello everyone!

I am working with several columns and would like to test if, among those columns, for each lines, at least two values are equal. It is easy to test that for two columns by having a simple test but I have no clue with several columns.

For example, I want to test if among the columns "col1", "col2" and "col3", we do have at least twice the same value. In the first line, we have twice "a", second line, we have nothing, third line, we have twice "b" and fourth line, we have three times "a". How should I write the formula that corresponds to column "test"?

col1 col2 col3 test
a a b ok
a b c x
b c b ok
a a a ok

Thank you very much!!

Hello popipipo!

Wow thank you for you efficiency in replying! However, it doesn't work... It gives me those results:
col1 col2 col3 test test2
a a b ok no dub
a b c x dub
b c b ok no dub
a a a ok dub

And you can see that doesn't give the same result between "test" and "test2"...

Thank you!!

Awesome!! Thank you so so much!!! :D It's working! I just applied the formula with the first line where the names of the columns are. So, what exactly does it mean: "(COUNTIF(A4:C4,A4)+COUNTIF(A4:C4,B4)+COUNTIF(A4:C4,C4))>3" ?

Thank you sosososo much!!!