The { formula } type of formula

[Guest]

About a year ago I got a formula from this site and was told that when I hit
enter I needed to do something else to make it work. It worked great at the
time but now I want to do it again and forget how. Can anyone help me?

 

[Guest]

from {your} title I asssume the formula is an array formula
It needs to be entered with control-shift-enter

 

[JE McGimpsey]

Take a look at "About array formulas and array constants" in XL Help,
where you'll find you'll need to enter array formulae with
CTRL-SHIFT-ENTER or CMD-RETURN, depending on platform.

 

[Ron Rosenfeld]

About a year ago I got a formula from this site and was told that when I hit
enter I needed to do something else to make it work. It worked great at the
time but now I want to do it again and forget how. Can anyone help me?

Hold down <ctrl><shift> while hitting <enter>. Excel will place the braces
{...} around this array formula.


--ron

 

[Guest]

I just tried that but had no luck. Could it be a setting? This is the formula
{=INDEX(Q1:Q54,SMALL(IF(Q1:Q54<>" ",ROW(V1:V54)),ROW(6:6)))}

 

[Guest]

remove the "{" and "}" from the cell and then use the control-shift-enter
if you typed in the { and } it thinks it is text. If you are getting an
error message, what is the message?

 

[RagDyer]

BTW,
Just clicking in the cell containing the formula (selecting it), and then
doing CSE, is *NOT* good enough.

Click in the *formula bar* after selecting the cell, and then do CSE.
--
HTH,

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

 

[Guest]

That was it..... Thanks for the help.

remove the "{" and "}" from the cell and then use the control-shift-enter
if you typed in the { and } it thinks it is text. If you are getting an
error message, what is the message?