array functions

  • Thread starter Thread starter Barak
  • Start date Start date
The same as a non-array function (F2 or mouse-click in formula bar), except
use CTRL-SHIFT-ENTER to commit the formula instead of just Enter.

HTH,
Elkar
 
If the array function is entered in multiple cells (instead of a single
cell), you need to select all of the cells before editing the function. As
already stated, after editing you must commit w/Cntrl+Shift+Enter
 
<<<"you need to select all of the cells before editing the function">>>

*Not* really so!

You can select *any single* formula cell in the array, revise it, then
simply use CSE to register the *entire* array range.
 
Because 9 times out of 10, most folks will make a revision, and then
*automatically* hit <Enter>, which with this type of formula, will invoke
the error message "cannot change part of an array".
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

LINEST multiple known_x's separated arrays 5
Array-friendly functions 1
Shape Arrays VBA 0
INDEX return multiple columns 1
Reverse a function to return the array? 4
Combining arrays for a Lookup function 5
Row references 1
INDEX function array causes problem when attempting to use LARGEfunction to sort positive and negati 10

Back
Top