Cell contains only 1 value

[Benong]

Hi,
How to check if a cell contains the same value (at least 3 values) on the same row across multiple columns?
Col A. Col B. Col C Col D
Car. Plane. Kettle Dog
1,1,1,1 0,0,0,0,0,0 1,0,11,0,0 1,1

Ans: Car, Plane (return values)

 

[Peter_SSs]

You're welcome. Glad we could help. Thanks for the follow-up.