earlier i worked with array formula very well. now i forgot and couldnot recall the method to edit the formula.

anybody help is highly appreciated.

hi bill,

try this....

after editing the formula, select the entire formula in the formula bar

and press ALT + CLTR + ENTER KEY.

all the best

thanks for the quick response. It worked out. You rock

"To enter a formula as an array formula, type the formula in the cell and
press the CTRL SHIFT and ENTER keys at the same time rather then just ENTER.
You must do this the first time you enter the formula and whenever you edit
the formula later. If you do this properly, Excel will display the formula
enclosed in curly braces { }. You do not type in the braces -- Excel will
display them automatically. If you neglect to enter the formula with CTRL
SHIFT ENTER, the formula may return a #VALUE error or return an incorrect
result."

Above is taken from http://www.cpearson.com/excel/ArrayFormulas.aspx

"bill_ball" wrote:


earlier i worked with array formula very well. now i forgot and couldnot
recall the method to edit the formula.

anybody help is highly appreciated.




--
bill_ball
.