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