2011/9/30 NOORAIN ANSARI <noorain.ans...@gmail.com> > Dear Nalini, > > See attached sheet if it help to u. > > On Thu, Sep 29, 2011 at 6:23 PM, N Pradhan > <nalini.pradha...@gmail.com>wrote: > >> ** >> Dear Noorain Sir, >> >> I am having some problem in the attached pivot. >> >> I want a calculated field (count of name - count of absent) which is >> non-numeric >> >> Please solve. >> >> Thanks >> >> N Pradhan >> >> ----- Original Message ----- >> >> *From:* NOORAIN ANSARI <noorain.ans...@gmail.com> >> *To:* excel-macros@googlegroups.com >> *Sent:* Thursday, September 22, 2011 11:08 AM >> *Subject:* Re: $$Excel-Macros$$ Ebooks for Pivot Table and Chart >> >> Dear Nalini, >> >> Please find attached sheet and below link for Pivot table & chart. >> http://chandoo.org/wp/2009/08/19/excel-pivot-tables-tutorial/ >> www.youtube.com/watch?v=R2yEH2lyzW0 >> ** >> -- >> Thanks & regards, >> Noorain Ansari >> *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> >> *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> >> >> On Thu, Sep 22, 2011 at 10:08 AM, N Pradhan >> <nalini.pradha...@gmail.com>wrote: >> >>> ** >>> Dear Sirs, >>> >>> Please send some ebooks or web address to learn pivot table and chart >>> (2007). >>> >>> >>> Thanks >>> >>> >>> >>> N Pradhan >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us on TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >>> 3. Excel tutorials at http://www.excel-macros.blogspot.com >>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >>> >>> To post to this group, send email to excel-macros@googlegroups.com >>> >>> <><><><><><><><><><><><><><><><><><><><><><> >>> Like our page on facebook , Just follow below link >>> http://www.facebook.com/discussexcel >>> >> >> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us on TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 >> 3. Excel tutorials at http://www.excel-macros.blogspot.com >> 4. Learn VBA Macros at http://www.quickvba.blogspot.com >> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com >> >> To post to this group, send email to excel-macros@googlegroups.com >> >> <><><><><><><><><><><><><><><><><><><><><><> >> Like our page on facebook , Just follow below link >> http://www.facebook.com/discussexcel >> > > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*<http://excelmacroworld.blogspot.com/> > *http://noorain-ansari.blogspot.com/*<http://noorain-ansari.blogspot.com/> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us on TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > To post to this group, send email to excel-macros@googlegroups.com > > <><><><><><><><><><><><><><><><><><><><><><> > Like our page on facebook , Just follow below link > http://www.facebook.com/discussexcel >
*Guide PivotTable in the aggregate, reports (Office 2003) *To create a Pivot Table you select the area containing all data,select the Data menu, select PivotTable Report ANF PivotCharup the box ... and PivotChar PivotTable Wizard - Step 1 of 3 Nextbutton, bring up the PivotTable ANF box PivotChar Wizard - Steptwo of 3 Next button, bring up the box ANF PivotChar PivotTableWizard - Step 3 of 3 new worksheet click the option (to create anew sheet) is complete click finish button to finish, here is you've taken and created the PivotTable data. Next you simply drag and drop objects in the table is finished. Note: the title and not all of the Cell Merge and center, if any onecell does not use the Merge and center can create PivotTable. -- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
