Remember Me?

#1
May 27th 05, 03:57 PM
 tkaplan Posts: n/a
ctrl+shift+enter vs enter

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

#2
May 27th 05, 04:14 PM
 Naz Posts: n/a

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

#3
May 27th 05, 04:14 PM
 papou Posts: n/a

Hello
If you mean the different ways of validating formulas, then ctrl+shift+enter
will validate an array formula.
HTH
Cordially
Pascal

"tkaplan" a écrit
dans le message de news:
...

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

#4
May 27th 05, 04:16 PM
 Ron de Bruin Posts: n/a

For the OP

See
http://www.cpearson.com/excel/array.htm

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Naz" wrote in message ...
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

#5
May 27th 05, 04:26 PM
 Naz Posts: n/a

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

#6
May 27th 05, 04:44 PM
 Ron de Bruin Posts: n/a

Hi Naz

Original Poster

--
Regards Ron de Bruin
http://www.rondebruin.nl

"Naz" wrote in message ...
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" wrote in message ...
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

#7
May 27th 05, 05:00 PM
 MrShorty Posts: n/a

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:a102),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

--
MrShorty
------------------------------------------------------------------------
MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181

#8
May 27th 05, 05:10 PM
 tkaplan Posts: n/a

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.

--
tkaplan
------------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...o&userid=22987

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Nadia Excel Discussion (Misc queries) 27 September 9th 05 03:39 PM Katybug1964 Excel Worksheet Functions 0 May 24th 05 03:32 PM Sarah_Lecturer Excel Discussion (Misc queries) 6 April 13th 05 10:01 PM darryll Excel Worksheet Functions 3 March 6th 05 05:26 AM danlinksman Excel Discussion (Misc queries) 3 December 4th 04 01:49 AM

All times are GMT +1. The time now is 07:58 PM.