Make sure you use ctrl-shift-enter to enter the formula.

If you do it correctly, you'll see that excel wraps your formula with curly
brackets {}.



TOM wrote:

Hello,

I want to compare the contents of a cell with the contents of a range of
cells by using the formula OR(EXACT(B1; A1:A300))

However, the result becomes only TRUE if the match is in the first cell of
the range, i.e. A1, if the match is in any other row it becomes FALSE. I
don't know why. It should be also TRUE id there is a match, shouldn't it?

Does anybody know the reason why the function does not work properly?

Is there another simple way to perform the desired task?

Happy New Year to everbody out there

Tom

--

Dave Peterson