array formular
 

some formulae just only work if entered in the form of array formular (Ctrl +
Shift + Enter). Could you pls tell me how excel calculates in the form of
array formular or provide me with any source explainning this.
Any help would be much appreciated.
LA

You won't get a better explanation than this

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

--

HTH

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


"LA" wrote in message
...
some formulae just only work if entered in the form of array formular
(Ctrl +
Shift + Enter). Could you pls tell me how excel calculates in the form of
array formular or provide me with any source explainning this.
Any help would be much appreciated.
LA

In addition, Chip Pearson has a nice explanation of how basic array formulas
work. See:

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

HTH
Jason
Atlanta, GA

"LA" wrote:

some formulae just only work if entered in the form of array formular (Ctrl +
Shift + Enter). Could you pls tell me how excel calculates in the form of
array formular or provide me with any source explainning this.
Any help would be much appreciated.
LA

tks very much for your help.

"Jason Morin" wrote:

In addition, Chip Pearson has a nice explanation of how basic array formulas
work. See:

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

HTH
Jason
Atlanta, GA

"LA" wrote:

some formulae just only work if entered in the form of array formular (Ctrl +
Shift + Enter). Could you pls tell me how excel calculates in the form of
array formular or provide me with any source explainning this.
Any help would be much appreciated.
LA

thank you so much. It really helps.

"Bob Phillips" wrote:

You won't get a better explanation than this

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

--

HTH

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


"LA" wrote in message
...
some formulae just only work if entered in the form of array formular
(Ctrl +
Shift + Enter). Could you pls tell me how excel calculates in the form of
array formular or provide me with any source explainning this.
Any help would be much appreciated.
LA