B
Barak
how I can edit array functions
thank
thank
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
E
Elkar
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
use CTRL-SHIFT-ENTER to commit the formula instead of just Enter.
HTH,
Elkar
J
JMB
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
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
R
RagDyer
<<<"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.
*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.
J
JMB
Not sure why I thought otherwise, but thanks for correcting me.
R
RagDyer
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".
*automatically* hit <Enter>, which with this type of formula, will invoke
the error message "cannot change part of an array".