Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
#4
|
|||
|
|||
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 |
#5
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to validate data entries to be unique within an array | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Where is the bug in my array? | Excel Discussion (Misc queries) | |||
Formula to list unique values | Excel Worksheet Functions | |||
VBA Import of text file & Array parsing of that data | Excel Discussion (Misc queries) |