Two arrays same?

T

T. Valko

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.
 
B

Bernd P

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
 
T

T. Valko

You could do this and still maintain the intuitive logic (are the cells
*equal*):

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

My preference would be the array formula.
 
Top