determining identical ranges

[upstate_steve]

Can someone refresh my memory as to the array formula one would use t
determine if the data in two ranges are identical?

Also, how would I return an array of the row numbers of the rows i
Range A that are not identical in Range B?

Thanks

Steve Przyborski
Boston, Mas

 

[Earl Kiosterud]

Steve,

=IF(AND(A2:A6=B2:B6),"Identical", "Mismatch")

Array-entered. Not case sensitive.

 

[Earl Kiosterud]

Steve,

I didn't read the second part of your post. Here's something that may be
better. In a helper column:

=if(A2<>B2,"X","") copy down with fill handle

This will put X in this column for mismatched rows. Now you can set up an
Autofilter and reduce the list to either matched or non-matched rows, and
deal with them.
--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

Steve,

=IF(AND(A2:A6=B2:B6),"Identical", "Mismatch")

Array-entered. Not case sensitive.