If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
excel formula help
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 |
#2
|
|||
|
|||
excel formula help
"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 . |
Thread Tools | |
Display Modes | |
|
|