You need to enter it with ctrl + shift & enter


--
Regards,

Peo Sjoblom


"Shawn K." <Shawn wrote in message
...
Very strange, the following simple formula is not working...
=OR(EXACT(A1, D1:D10))

it does not go through the range.... and compare

Thanks.
Shawn