The { formula } type of formula
 

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?

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

"Alex" wrote:

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?

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.

In article ,
"Alex" wrote:

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?

On Fri, 17 Jun 2005 10:16:02 -0700, "Alex"
wrote:

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

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


"bj" wrote:

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

"Alex" wrote:

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?

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?

"Alex" wrote:

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


"bj" wrote:

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

"Alex" wrote:

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?

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


"Alex" wrote in message
...
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)))}


"bj" wrote:

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

"Alex" wrote:

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?

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

"bj" wrote:

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?

"Alex" wrote:

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


"bj" wrote:

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

"Alex" wrote:

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?