Thread: Array Function
View Single Post
  #9   Report Post  
Mangus Pyke
 
Posts: n/a
Default

On 18 Jul 2005 08:58:09 -0700, "Egon" wrote:
if I may ask, what does the CTRL+SHIFT+Enter do?

I've never seen that before.


Also called "CSE formulas", this forces Excel to use the data as an
array.

Excel will enter the formula as an array and place curly brackets
around it to identify it as such.

Entering an array by manually including the curly brackets doesn't
work, so Ctrl-Shift-Enter must be used.

MP-
--
"Learning is a behavior that results from consequences."
B.F. Skinner