Re: $$Excel-Macros$$ Required Challenging formula

2012-09-21 Thread Vabz
Hi, In last code given put Y agaist promoter & u will get data for only promoters.. Rgds//Vabs On Friday, September 21, 2012 10:10:50 AM UTC+5:30, amar takale wrote: > > Hi Vabz > I create file with index formula now I want to In Output(2) sheet all > promoter in one shot for all Qtr.I used Da

Re: $$Excel-Macros$$ Required Challenging formula

2012-09-20 Thread amar takale
Hi VabZ Currently I am not create sheet But In my mind that type of idea generated So I will try it. If I will create this sample file I will send it Then you Guide me further activity Thanks very much On Thu, Sep 20, 2012 at 12:54 PM, Vabz wrote: > Hi > > can you share your sample result data

Re: $$Excel-Macros$$ Required Challenging formula

2012-09-20 Thread Vabz
Hi can you share your sample result data in given example in separate sheet. Rgds//Vabs On Thursday, September 20, 2012 12:19:01 PM UTC+5:30, amar takale wrote: > > Dear Vabs > I already use auto filter to get data.With auto filter I will get only One > Year Data But I want all Data in one sho

Re: $$Excel-Macros$$ Required Challenging formula

2012-09-19 Thread amar takale
Dear Vabs I already use auto filter to get data.With auto filter I will get only One Year Data But I want all Data in one shot On Thu, Sep 20, 2012 at 12:06 PM, Vabz wrote: > Hi > > Why dont you use filer to get data. > > Rgds//Vabs > > > On Thursday, September 20, 2012 11:44:56 AM UTC+5:30, ama

Re: $$Excel-Macros$$ Required Challenging formula

2012-09-19 Thread Vabz
Hi Why dont you use filer to get data. Rgds//Vabs On Thursday, September 20, 2012 11:44:56 AM UTC+5:30, amar takale wrote: > > Hi All Champs, > Anybody help me regarding tup formula solution. > Q: I want to see Sector wise promotor,FII & so on (From Dec04-Jun05) in > one shot.When I click sect

Re: $$Excel-Macros$$ Required Challenging formula

2012-08-22 Thread amar takale
Dear NOORAIN, Thanks for reply,I used this formula but not work it show #VALUE! .I think formula is correct but how to use in it offset.why formula not work? On Wed, Aug 22, 2012 at 10:00 PM, NOORAIN ANSARI wrote: > Dear Amar, > > pls Try it.. > > > =SUMPRODUCT((List=OFFSET($A$2,$AI$3,0))*($B$3:$

Re: $$Excel-Macros$$ Required Challenging formula

2012-08-22 Thread NOORAIN ANSARI
Dear Amar, pls Try it.. =SUMPRODUCT((List=OFFSET($A$2,$AI$3,0))*($B$3:$B$50=AK$7)*($C$2:$N$2=$AJ8)*($C$3:$N$50)) On Wed, Aug 22, 2012 at 2:54 PM, amar takale wrote: > > -- > Join official facebook page of this forum @ > https://www.facebook.com/discussexcel > > FORUM RULES (1120+ members alre