Hello,

Biff already provided two solutions.

But if you need to be a little bit more tolerant with regards to text
& numbers, for example if the text 2 should be treated as being
identical to the number 2 then use
=SUMPRODUCT(--(EXACT(A1:J1,A10:J10)))=10

Regards,
Bernd