Prev: How do you hide/un-hide the grid lines
Next: Quick formula help please
From: GeorgeA on 19 May 2010 14:33
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" <GeorgeA(a)discussions.microsoft.com> wrote in message
> news:AEE49CB4-577B-40E4-9B1F-626FFD2204E2(a)microsoft.com...
> |I have a formula that shows as:
> | {=A5-INDEX(A5:A400,MATCH(TRUE,K5:K400>0,0))}
> |
> | It works but I want to change it to:
> | {=A5-INDEX(A5:A400,MATCH(TRUE,J5:J400>B6,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!
> |
>
> .
>
First  |  Prev  | 
Pages: 1 2
Prev: How do you hide/un-hide the grid lines
Next: Quick formula help please