| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
formula with {}
Thanks for the quick response!
"Homey" wrote: after you chang formuls dont just press enter. instead press ctrl-shift-enter. this is call 'array-entering'. "GeorgeA" wrote in message ... |I have a formula that shows as: | {=A5-INDEX(A5:A400,MATCH(TRUE,K5:K4000,0))} | | It works but I want to change it to: | {=A5-INDEX(A5:A400,MATCH(TRUE,J5:J400B6,0))} | | Problem is that when I click to edit the formula, the {} brackets disappear | and then the formula returns $VALUE!. | | Why do these brackets show up and how do I edit this formula? | | Thanks, any help would be appreciated! | . |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Hybrid Mode
