I've seen it posted in a few other threads while browsing the forums but don't know what it does.
I've seen it posted in a few other threads while browsing the forums but don't know what it does.
Hi, the following came right out of Help in Excel. If you open Help and type
in "array formula", you'll get some help on creating and working with array
formulas, as well examples to help explain what an array is.
An array formula can perform multiple calculations and then return either a
single result or multiple results. Array formulas act on two or more sets of
values known as array arguments. Each array argument must have the same
number of rows and columns. You create array formulas in the same way that
you create other formulas, except you press CTRL+SHIFT+ENTER to enter the
formula.
"qwopzxnm" wrote:
>
> I've seen it posted in a few other threads while browsing the forums but
> don't know what it does.
>
>
> --
> qwopzxnm
> ------------------------------------------------------------------------
> qwopzxnm's Profile: http://www.excelforum.com/member.php...o&userid=27557
> View this thread: http://www.excelforum.com/showthread...hreadid=477953
>
>
Chip Pearson has some notes at:
http://www.cpearson.com/excel/array.htm
qwopzxnm wrote:
>
> I've seen it posted in a few other threads while browsing the forums but
> don't know what it does.
>
> --
> qwopzxnm
> ------------------------------------------------------------------------
> qwopzxnm's Profile: http://www.excelforum.com/member.php...o&userid=27557
> View this thread: http://www.excelforum.com/showthread...hreadid=477953
--
Dave Peterson
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks