CNTL + SHIFT + ENTER

[Houstonwolf]

Why do some formulas have to be entered with the Control/Shift/Enter combination? What is the criteria or how would you decide if a particular formula required that combination? I don't think I've ever seen an explanation.

Thanks!

 

[Andrew Poulsom]

Some light reading:

http://www.emailoffice.com/excel/arrays-bobumlas.html

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

 

[Joe4]

Check out this topic in Excel help:

"About array formulas and how to enter them"