array formulas
 

some formulas are normal formulas.
some are array formulas requiring ctrl+shift+enter

is there any way of distringuishing between these two types from looking at
the formulas

In the formula bar, array formulas appear in curly brackets {}

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"R.VENKATARAMAN" wrote in message
...
some formulas are normal formulas.
some are array formulas requiring ctrl+shift+enter

is there any way of distringuishing between these two types from looking
at
the formulas

array formula is inside curly braces {}

Mangesh


--
mangesh_yadav
------------------------------------------------------------------------
mangesh_yadav's Profile: http://www.excelforum.com/member.php...o&userid=10470
View this thread: http://www.excelforum.com/showthread...hreadid=379600

sorry I did not frame the question correctly.
what I meant is suppose I get some foirmula from one of the newsgroups and
forgot to download the whole message I would like to know how to distinguish
the formula. does it mean when I copy the formula in a cell automatically
the curly brackets will appear in the formula bar?




Niek Otten wrote in message
...
In the formula bar, array formulas appear in curly brackets {}

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"R.VENKATARAMAN" wrote in message
...
some formulas are normal formulas.
some are array formulas requiring ctrl+shift+enter

is there any way of distringuishing between these two types from looking
at
the formulas

No it doesn't, you need to add them by committing with Ctrl-Shift-Enter, not
just Enter.

It can be worse if they include {..} in their response as you then have to
remove them. But this is similar to long formulae that extend over multiple
lines, I have to re-join these back in Excel.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"R.VENKATARAMAN" wrote in message
...
sorry I did not frame the question correctly.
what I meant is suppose I get some foirmula from one of the newsgroups and
forgot to download the whole message I would like to know how to
distinguish
the formula. does it mean when I copy the formula in a cell automatically
the curly brackets will appear in the formula bar?




Niek Otten wrote in message
...
In the formula bar, array formulas appear in curly brackets {}

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"R.VENKATARAMAN" wrote in message
...
some formulas are normal formulas.
some are array formulas requiring ctrl+shift+enter

is there any way of distringuishing between these two types from
looking
at
the formulas

On Thu, 16 Jun 2005 12:26:38 +0100, "Bob Phillips"
wrote:

It can be worse if they include {..} in their response as you then have to
remove them. But this is similar to long formulae that extend over multiple
lines, I have to re-join these back in Excel.

But only remove those brackets that are at the beginning and end of the
formula; don't remove any brackets that are inside the formula as they
represent array constants.

e.g.

{=SUM(--(A1:A10={1,2,3,4}))}

Remove the outside brackets and not those representing the array constant:

=SUM(--(A1:A10={1,2,3,4}))


--ron

Good point :-)

Bob


"Ron Rosenfeld" wrote in message
...
On Thu, 16 Jun 2005 12:26:38 +0100, "Bob Phillips"
wrote:

It can be worse if they include {..} in their response as you then have
to
remove them. But this is similar to long formulae that extend over
multiple
lines, I have to re-join these back in Excel.

But only remove those brackets that are at the beginning and end of the
formula; don't remove any brackets that are inside the formula as they
represent array constants.

e.g.

{=SUM(--(A1:A10={1,2,3,4}))}

Remove the outside brackets and not those representing the array constant:

=SUM(--(A1:A10={1,2,3,4}))


--ron

In the formula status bar you should see the formula in brackets {=formula}

"R.VENKATARAMAN" wrote:

some formulas are normal formulas.
some are array formulas requiring ctrl+shift+enter

is there any way of distringuishing between these two types from looking at
the formulas