Comparing two matrices

[mahadevan.swamy]

I have two matrices where both of them having same number of columns
and rows. Each matrix has 32 columns and infinite rows. Now what I
would like to do is to compare if the rows of the two matrices are the
same or not and assign an appropriate result: "MATCH" or "NO MATCH".

I am looking for the overall summary instead of comparing each and
every column of the two matrices. Any ideas?

Thanks in advance.

Mahadevan Swamy

 

[Ron Rosenfeld]

I have two matrices where both of them having same number of columns
and rows. Each matrix has 32 columns and infinite rows. Now what I
would like to do is to compare if the rows of the two matrices are the
same or not and assign an appropriate result: "MATCH" or "NO MATCH".

I am looking for the overall summary instead of comparing each and
every column of the two matrices. Any ideas?

Thanks in advance.

Mahadevan Swamy

A formula of the type:

=AND(A1:Z1=AA1:AZ1) **array-entered** (Hold down <ctrl><shift> while hitting
the <enter> key. XL will place braces {...} around the formula if you did it
correctly) will return TRUE if the rows match, and FALSE if they do not.

So you could use an **array** formula of the type:

=IF(AND(A1:Z1=AA1:AZ1),"MATCH","NO MATCH")


--ron