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 > ctrlshiftenter. this is call 'arrayentering'. > > "GeorgeA" <GeorgeA(a)discussions.microsoft.com> wrote in message > news:AEE49CB4577B40E49B1F626FFD2204E2(a)microsoft.com... > I have a formula that shows as: >  {=A5INDEX(A5:A400,MATCH(TRUE,K5:K400>0,0))} >  >  It works but I want to change it to: >  {=A5INDEX(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/unhide the grid lines Next: Quick formula help please 