array formular

[Guest]

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

 

[Bob Phillips]

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)

 

[Guest]

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

 

[Guest]

tks very much for your help.

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

 

[Guest]

thank you so much. It really helps.

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)