Rahul, So you select your source and create a pivot table. Take date in the row field and Average of VND=.... in data column.
Now use grouping in the date column and select the time period is month. Again use grouping in the month column and select the time period as year. And voila! you have two columns, year and month along with the average of VND. Post back if you need any help Regards, Sam Mathai Chacko (GL) On Tue, Oct 4, 2011 at 9:24 PM, Rahul Garwad <garwads...@gmail.com> wrote: > 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 > -- 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
