<<<"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.
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"JMB" wrote in message
...
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

"Barak" wrote:

how I can edit array functions
thank