The { formula } type of formula

A

Alex

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?
 
B

bj

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

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.
 
R

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?
Click to expand...

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


--ron
 
A

Alex

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)))}
 
B

bj

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?
 
R

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

Alex

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

bj said:
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?
Click to expand...
 
Top