what is the difference btw confirming with enter and ctrl+shift+enter?
what is the difference btw confirming with enter and ctrl+shift+enter?
enter confirms a normal formula.
ctrl+shift+enter confirms an array formula (search Excel help for array formula and you'll find some information). Array formulae come in two types:
1) Performs a calculation on each element of an array in the process of acheiving the results. SUMPRODUCT is often used in this way (=sumproduct(--(a1:a10>2),b1:b10). Because it performs the comparison step on each element in the range, it needs to be entered as an array formula.
2) An array formula can also return multiple values in the process of acheiving its result. Matrix functions (MMULT, TRANSPOSE, etc) fall into this category. Functions like LINEST and LOGEST which return two parameters for the given curve fit.
That's a little information on array formulas. They can be useful tools in a spreadsheet, depending on what you need to make a spreadsheet do.
The difference is that for a normal formula you use Enter,
However there is a special kind of formula called an Array formula which can
only be entered using Ctrl+****+Enter. When doing so it will enter special
curly brackets to indicate it is an Array formula
--
_______________________
Naz,
London
"tkaplan" wrote:
>
> what is the difference btw confirming with enter and ctrl+shift+enter?
>
>
> --
> tkaplan
> ------------------------------------------------------------------------
> tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
> View this thread: http://www.excelforum.com/showthread...hreadid=374550
>
>
Hello
If you mean the different ways of validating formulas, then ctrl+shift+enter
will validate an array formula.
HTH
Cordially
Pascal
"tkaplan" <[email protected]> a écrit
dans le message de news:
[email protected]...
>
> what is the difference btw confirming with enter and ctrl+shift+enter?
>
>
> --
> tkaplan
> ------------------------------------------------------------------------
> tkaplan's Profile:
> http://www.excelforum.com/member.php...o&userid=22987
> View this thread: http://www.excelforum.com/showthread...hreadid=374550
>
For the OP
See
http://www.cpearson.com/excel/array.htm
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Naz" <[email protected]> wrote in message news:[email protected]...
> The difference is that for a normal formula you use Enter,
> However there is a special kind of formula called an Array formula which can
> only be entered using Ctrl+****+Enter. When doing so it will enter special
> curly brackets to indicate it is an Array formula
>
>
> --
>
> _______________________
> Naz,
> London
>
>
> "tkaplan" wrote:
>
>>
>> what is the difference btw confirming with enter and ctrl+shift+enter?
>>
>>
>> --
>> tkaplan
>> ------------------------------------------------------------------------
>> tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
>> View this thread: http://www.excelforum.com/showthread...hreadid=374550
>>
>>
Sorry Ron, whats OP ?
--
_______________________
Naz,
London
"Ron de Bruin" wrote:
> For the OP
>
> See
> http://www.cpearson.com/excel/array.htm
>
>
>
>
> --
> Regards Ron de Bruin
> http://www.rondebruin.nl
>
>
>
> "Naz" <[email protected]> wrote in message news:[email protected]...
> > The difference is that for a normal formula you use Enter,
> > However there is a special kind of formula called an Array formula which can
> > only be entered using Ctrl+****+Enter. When doing so it will enter special
> > curly brackets to indicate it is an Array formula
> >
> >
> > --
> >
> > _______________________
> > Naz,
> > London
> >
> >
> > "tkaplan" wrote:
> >
> >>
> >> what is the difference btw confirming with enter and ctrl+shift+enter?
> >>
> >>
> >> --
> >> tkaplan
> >> ------------------------------------------------------------------------
> >> tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
> >> View this thread: http://www.excelforum.com/showthread...hreadid=374550
> >>
> >>
>
>
>
Hi Naz
Original Poster
--
Regards Ron de Bruin
http://www.rondebruin.nl
"Naz" <[email protected]> wrote in message news:[email protected]...
> Sorry Ron, whats OP ?
> --
>
> _______________________
> Naz,
> London
>
>
> "Ron de Bruin" wrote:
>
>> For the OP
>>
>> See
>> http://www.cpearson.com/excel/array.htm
>>
>>
>>
>>
>> --
>> Regards Ron de Bruin
>> http://www.rondebruin.nl
>>
>>
>>
>> "Naz" <[email protected]> wrote in message news:[email protected]...
>> > The difference is that for a normal formula you use Enter,
>> > However there is a special kind of formula called an Array formula which can
>> > only be entered using Ctrl+****+Enter. When doing so it will enter special
>> > curly brackets to indicate it is an Array formula
>> >
>> >
>> > --
>> >
>> > _______________________
>> > Naz,
>> > London
>> >
>> >
>> > "tkaplan" wrote:
>> >
>> >>
>> >> what is the difference btw confirming with enter and ctrl+shift+enter?
>> >>
>> >>
>> >> --
>> >> tkaplan
>> >> ------------------------------------------------------------------------
>> >> tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987
>> >> View this thread: http://www.excelforum.com/showthread...hreadid=374550
>> >>
>> >>
>>
>>
>>
thank you.
wow i feel so stupid that i didnt know that....
i usually do all my array stuff with VB so i never tried that.
but good to know.
thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks