Hi,

We need more information - are you trying to compare every cell in one range
with every one in another range and determine if or how many are exact
matches. Note this is different than comparing cell by cel. For example
A1 B1
A2 B2
A3 B3

Do you want to check if A1 is in any of the cells B1:B3 or just compare it
with B1?

If you wanted to check A1 against all the cells in B1:B3 it would be

=OR(EXACT(A1,B1:B3))

entered as an array (Shift+Ctrl+Enter)

If you wanted to compare A1 to B1, A2 to B2 and determine how many were
exact matches the formula would be

=SUMPRODUCT(--EXACT(A1:A3,B1:B3))

If you are trying to find out how many items in column A are also in column
B regardless of position then

=SUMPRODUCT(COUNTIF(A1:A3,B1:B3))

But this is not a case sensitive count.


--
Thanks,
Shane Devenshire


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