The following array formula will return the number of EXACT matches in
the range A1:A6 compared, row by row, with B1:B6.

=SUM(1*(EXACT(A1:A6,B1:B6)))

The following array formula will return TRUE if all cells in A1:A6 are
exact matches, row by row, with the values in B1:B6. It will return
FALSE if one or more pair of cells are not an exact match.

=SUM(1*EXACT(A1:A6,B1:B6))=ROWS(A1:A6)

EXACT performs a case-sensitive match. E.g., "A" is not equal to "a".

These are both array formulas, so you must press CTRL SHIFT ENTER
rather than just ENTER when you first enter the formula and whenever
you edit it later. If you do this properly, Excel will display the
formula enclosed in curly braces { }. See
http://www.cpearson.com/Excel/arrayformulas.aspx for must more
information about array formulas.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)


On Sun, 26 Oct 2008 07:14:01 -0700, markholt
wrote:

I'm trying to use the =OR(Exact) & compare a range of cells. Having
problems. It seems to work when the cells are in the same row, but not when
comparing to cells in different rows in the range.