Try one of these:

=SUMPRODUCT(--(A1:J1=A10:J10))=10

Or, array entered** :

=AND(A1:J1=A10:J10)

** array formulas need to be entered using the key combination of
CTRL,SHIFT,ENTER (not just ENTER). Hold down both the CTRL key and the SHIFT
key then hit ENTER.

--
Biff
Microsoft Excel MVP


"FARAZ QURESHI" wrote in message
...
What formula could tell A1:J1 = A10:J10?