$$Excel-Macros$$ Re: Required Revenue started from Date..

2012-09-09 Thread Prince Dubey
Nice formula Don regards prince On Friday, August 31, 2012 6:05:54 PM UTC+5:30, Kuldeep Singh wrote: > > > Hi Experts, > > I want to required Revenue started from Date. > > > Regards, > Kuldeep Singh > Phone.: +91-120-4763789, Extn.: 789 > naukri...@gmail.com || www.naukri.com > *Please* *Consid

Re: $$Excel-Macros$$ Re: Required Revenue started from Date..

2012-09-02 Thread Kuldeep Singh
Hi Vabs, You can use this formula & Press Ctrl+Shift+Enter. =INDEX($1:$1,0,SMALL(IF(C2:R2>0,COLUMN($C$1:$R$1),""),1)) Regards, Kuldeep Singh Phone.: +91-120-4763789, Extn.: 789 naukrikuld...@gmail.com || www.naukri.com *Please* *Consider the environment. Please don't print this e-mail unless you

$$Excel-Macros$$ Re: Required Revenue started from Date..

2012-09-02 Thread Vabs
hii I tried doing without arrat formulae or vba.. Hope it doesnt throw error. Rgds//Vabs On Friday, August 31, 2012 6:05:54 PM UTC+5:30, Kuldeep Singh wrote: > > Hi Experts, > > I want to required Revenue started from Date. > > > Regards, > Kuldeep Singh > Phone.: +91-120-4763789, Extn.: