Are you aware that this is an *array* formula?

Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of the
regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"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

Comparing a value to a list of values does not work in Excel 2003.
 

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

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

Excuse my clock!<g
"RagDyer" wrote in message
...
Are you aware that this is an *array* formula?

Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of the
regular <Enter, which will *automatically* enclose the formula in curly
brackets, which *cannot* be done manually.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"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