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

R

RagDyer

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!
==============================================


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
 
G

Guest

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
 
R

RagDyer

Excuse my clock!<g>
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!
==============================================


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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I can't enter an array in Excel 2007 2
Formula Question for Excel 2003 5
Comparing two spreadsheets part 2 10
LookUp (Date) Value from Forecast Data - From 2nd Sheet 3
Extracting elements of a string cell 11
How to locate the first digit in a cell, explained 7
Array function does not seem to work 19
Count number of cols which contain a value(s) in it less than x(array formula?) 1

Top