Can't get {} woking

[Guest]

I tried

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

Thanks ahead!

Rob

 

[Ron Rosenfeld]

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

 

[Guest]

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-ROW(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

 

[T. Valko]

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

 

[Ron Rosenfeld]

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-ROW(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

If you are entering the formula properly, and Excel is placing the {...}'s
after you strike <enter> while holding down <ctrl><shift>, then there may be a
problem with your data, compared with the data upon which the formula was
based. Or there may be a problem with your references.

Do you see the {...} brackets after you enter the formula? (Don't type them in
yourself; let Excel add them).
--ron

 

[Guest]

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

 

[Ragdyer]

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

 

[Guest]

Thanks Ragdyer that did the trick.

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

 

[Ragdyer]

You're welcome, and thanks for the feed-back.