Click in the cell that contains the formula, where you see the actual
formula in the formula bar.

Look below, at the status bar, just above the Windows <Start button.
You'll see "READY"!

For you to enter this formula as an array formula, the status bar *MUST*
first say "EDIT".

To get into "Edit Mode", you do one of two things.
Either:
Click in the formula bar,
OR
Hit <F2.

With the status bar displaying "Edit",
NOW ... hit CSE (<Ctrl <Shift <Enter)!
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Killer" wrote in message
...
I understand anytime I edit anything regarding array formula that I need
to
use the CTRL,SHIFT,ENTER command. The problem is I'm doing that and it's
not
working. The formula is correct as it works but even when I'm checking the
formula in the box area it gives that error afterwards and that because
the
array formula is not there now.

So then I try to activate it by clicking CTRL,SHIFT,ENTER and isn't
applying
the array formula.

Is there something else that could be stopping me from getting this array
formula command working like key commands?

Take Care!

Rob


"T. Valko" wrote:

Whenever you edit an array formula you *must* re-enter it as an array
with
the key combo of CTRL,SHIFT,ENTER.

I've never heard of Excel *not* applying the array brackets if this is
done
properly. Hold down both the CTRL key and the SHIFT key then hit ENTER.

Biff

"Killer" wrote in message
...
Hey Ron

Here's the formula


=IF(ROWS(1:$1)<=COUNTA(B$13:B$45),INDEX(B$13:B$45, MATCH(LARGE(AM$13:AM$45-RO
W(AM$13:AM$45)/10^10,ROWS(1:$1)),AM$13:AM$45-ROW(AM$13:AM$45)/10^10,0)),"")

It woks I know this much but if I edited anything at all I get a
#VALUE!
error.

Thanks ahead!

Rob


"Ron Rosenfeld" wrote:

On Fri, 22 Jun 2007 16:04:01 -0700, Killer

wrote:

I tried

CTRL, Shift and Enter and t doesn't add the command that is required
is
there something I missing?

Thanks ahead!

Rob

What formula are you committing?
--ron