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

On 1 May 2007 05:42:48 -0700, wrote:

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