Re: $$Excel-Macros$$ excel query

2014-02-11 Thread Naveen Kumar M N
bcoz it will be calculated for 360 days/year no problem just go for this simple technique =enddate-startdate+1 From Naveenkumar On Wed, Feb 12, 2014 at 10:07 AM, Shankar Bheema wrote: > Thank you naveen for providing solution > > Wherein, the difference between dates from 01-01-2014 to 31-01-

Re: $$Excel-Macros$$ excel query

2014-02-11 Thread Shankar Bheema
Thank you naveen for providing solution Wherein, the difference between dates from 01-01-2014 to 31-01-2014 is 31 days, but with the formula it is showing 30 days just short of 1 day. How can I get the one day added to that column On Tue, Feb 11, 2014 at 6:03 PM, Naveen Kumar M N < naveenkumarm

Re: $$Excel-Macros$$ excel query

2014-02-10 Thread Anil Gawli
Dear Shankar, Pl find attached. Warm Regards, Gawli Anil. On Mon, Feb 10, 2014 at 2:27 PM, Shankar Bheema wrote: > Dear all, > > I attached an excel workbook which contains 3 worksheets. worksheet1 is > named as Members worksheet2 is with membername and worksheet 3 is also named > after the me

Re: $$Excel-Macros$$ Excel Query-(Appreciate the help)

2012-12-13 Thread amar takale
Dear Pravin, Solution is Perfect as like me.How to do it, any logic for code (true & false) I will also try for 4th chart.And one more Chart is movable from here to there Can I fixed this one place. Thanks again Amar On Fri, Dec 14, 2012 at 10:38 AM, Pravin Gunjal wrote: > *Hi Amar,* > * > *

Re: $$Excel-Macros$$ Excel query

2011-06-20 Thread Maries
Hi Vikas, Answer (a): Use the Shortcut *" Alt + ; " Apply Filter ==> Select Data ==> Alt + ; ==> Copy ==> Paste* Rgds, Maries On Mon, Jun 20, 2011 at 12:00 PM, Vikas Agarwal wrote: > Hi All, > > I need help on two things: > > a) I have filtered data from a large range (say A1 to A20).

Re: $$Excel-Macros$$ Excel query

2011-06-20 Thread anil panchal
Hi Vikas, Ans For 1 Question Please Select Data after Filter & Press Ctrl+Alt+L then Copy & Paste For 2nd Question Please send sample data Thanks & Regards Anil Kumar 113784 On Mon, Jun 20, 2011 at 1:00 AM, Vikas Agarwal wrote: > Hi All, > > I need help on two things: > > a) I have filte

Re: $$Excel-Macros$$ excel query

2011-06-17 Thread sunny k
hi azeema can you tell us in which format you want the output On Wed, Jun 15, 2011 at 11:03 PM, Azeema Faizunnisa wrote: > thanks everyone for offer of help. Here is the sample data. > > On Wed, Jun 15, 2011 at 1:31 AM, Venkatesan c > wrote: > > Hi Azeema, > > Send the sample data and some on

Re: $$Excel-Macros$$ excel query

2011-06-15 Thread Azeema Faizunnisa
thanks everyone for offer of help. Here is the sample data. On Wed, Jun 15, 2011 at 1:31 AM, Venkatesan c wrote: > HiĀ Azeema, > Send the sample data and some one will assist the query.. > Best Regards, > Venkat.. > > > On Wed, Jun 15, 2011 at 2:38 PM, Azeema Faizunnisa wrote: >> >> I have a tabl

Re: $$Excel-Macros$$ excel query

2011-06-15 Thread Venkatesan c
Hi Azeema, Send the sample data and some one will assist the query.. Best Regards, Venkat.. On Wed, Jun 15, 2011 at 2:38 PM, Azeema Faizunnisa wrote: > I have a table in excel of # of employees by age, sex and category of > employment. The ROWs have three diff categories by sex and the COLU

Re: $$Excel-Macros$$ excel query

2011-06-15 Thread ashish koul
can you attach the sample workbook On Wed, Jun 15, 2011 at 2:38 PM, Azeema Faizunnisa wrote: > I have a table in excel of # of employees by age, sex and category of > employment. The ROWs have three diff categories by sex and the COLUMNS > have age (5 10-year age groups). Each cell provides the