Thanks Sam, Could you please explain the method used ?
Regards Rahul. On Tue, Oct 4, 2011 at 8:59 PM, Sam Mathai Chacko <samde...@gmail.com> wrote: > Rahul, > > PFA the pivot > > Regards, > > Sam Mathai Chacko (GL) > > On Tue, Oct 4, 2011 at 6:59 PM, Rahul Garwad <garwads...@gmail.com> wrote: >> >> Hi Prince, >> >> As mentioned earlier, i need to it this format as in Column "AA" to >> "AC" present in sheet below. >> >> Thanks for your try. >> >> Average of UGX=, Cndl, Close >> Years date Total >> 1994 Feb 978.75 >> Mar 1016.40 >> Apr 986.11 >> May 948.24 >> Jun 952.28 >> Jul 954.15 >> Aug 908.04 >> Sep 907.76 >> Oct 912.19 >> Nov 912.95 >> Dec 919.82 >> 1995 Jan 914.77 >> Feb 918.25 >> Mar 920.26 >> >> >> On Tue, Oct 4, 2011 at 6:55 PM, Prince Maurya >> <princeone.mau...@gmail.com> wrote: >> > Fist convert the col AE into DD-MM-YY then use pivot..in sheet 1 workn >> > hs >> > done...pls chk. >> > >> > On Tue, Oct 4, 2011 at 5:04 PM, Rahul Garwad <garwads...@gmail.com> >> > wrote: >> >> >> >> Hi Guys, >> >> >> >> Pls find below sheet and let me know how to do the Pivot present in >> >> Column "AA" to "AC" converting one header "DATE" into YEAR and MONTH. >> >> >> >> I want to prepare same pivot with data from Column "A" to "E" . >> >> >> >> Please let me know if i'm not clear or for more info. >> >> >> >> Regards >> >> >> >> Rahul. >> >> >> >> -- >> >> >> >> >> >> ---------------------------------------------------------------------------------- >> >> 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 > > > > -- > Sam Mathai Chacko > > -- > ---------------------------------------------------------------------------------- > 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
