Re: $$Excel-Macros$$ Guru's Pls reply me

2011-09-02 Thread kannan excel
Thanks:) On Wed, Aug 31, 2011 at 10:36 PM, NOORAIN ANSARI wrote: > Dear Kanan, > > Please see attached sheet.. > > On Tue, Aug 30, 2011 at 6:25 PM, kannan excel wrote: > >> Hi Excel Guru's, >> >> PFA >> >> pls help me. i want to report for daily actions. like Activation how much, >> rejectio

Re: $$Excel-Macros$$ Guru's Pls reply me

2011-08-31 Thread Venkat CV
Hi Kannan, Look attached used formulas... =COUNTIFS(Sheet1!$B:$B,Sheet3!$A2,Sheet1!$E:$E,Sheet3!H$1) *Best Regards,* *Venkat * *Chennai* * * On Wed, Aug 31, 2011 at 11:02 AM, kannan excel wrote: > Sorry guys. > > > I don't want pivot table. i want like that any macro or formulas. > > help me >

Re: $$Excel-Macros$$ Guru's Pls reply me

2011-08-31 Thread kannan excel
Sorry guys. I don't want pivot table. i want like that any macro or formulas. help me On Tue, Aug 30, 2011 at 8:21 PM, Rajan_Verma wrote: > *Hi* > > *See the attached ,* > > *First we need to create a NameRange and need to put that in Pivot Table > dataSource ,* > > * * > > *Hope it will help