You are welcome Robin.. On Fri, Jan 8, 2010 at 1:30 PM, Robinson Boreh <rbo...@gmail.com> wrote:
> *Hi Praveen,* > ** > *Thanks. That's what I needed, only I do not know how to go about in in > pivot tables.* > *Regards* > *Boreh* > > ------------------------------ > *From:* excel-macros@googlegroups.com [mailto: > excel-mac...@googlegroups.com] *On Behalf Of *kvc praveen kumar > *Sent:* Thursday, January 07, 2010 8:47 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ Help needed > > Hi Robin, > > You can check the attached file. Hope it helps. > > Regards, > Praveen > > On Thu, Jan 7, 2010 at 5:01 PM, Robinson Boreh <rbo...@gmail.com> wrote: > >> *Hi Praveen,* >> *Thanks for the effort. I still need to incorporate the count of number >> of deposits. * >> *Regards* >> >> ------------------------------ >> *From:* excel-macros@googlegroups.com [mailto: >> excel-mac...@googlegroups.com] *On Behalf Of *kvc praveen kumar >> *Sent:* Thursday, January 07, 2010 1:19 PM >> >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ Help needed >> >> Hi Robin, >> >> I did not get exactly what you require as i dont understand Finance much. >> But I created a pivot table as per your requirement in sheet3. >> I hope it helps. >> >> Please check and let me know. >> >> Regards, >> Praveen >> >> >> On Thu, Jan 7, 2010 at 3:11 PM, Robinson Boreh <rbo...@gmail.com> wrote: >> >>> Hi guyz, >>> Thanks for the good work you are doing. Am elated to have joined this >>> group and again cheers to you all. >>> All that aside I need your assistance. >>> I need to have a report with the columns and rows as follows >>> >>> >>> Range Type of Deposit Number of >>> deposits Amount >>> >>> Less than 50,000 >>> 50,000 - 100,000 >>> 100,001 - 500,000 >>> 500,001-1,000,000 >>> Over 1,000,00 >>> >>> Attached, please find the data in excel. >>> Regards >>> >>> *Robinson Boreh, * >>> >>> *Finanace Department, Upper Hill,* >>> >>> *Tel: 2874243, 0711019243 Fax: 2719705* >>> >>> -- >>> >>> ---------------------------------------------------------------------------------- >>> Some important links for excel users: >>> 1. Follow us in TWITTER for tips tricks and links : >>> http://twitter.com/exceldailytip >>> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >>> http://www.excelitems.com >>> 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 >>> If you find any spam message in the group, please send an email to: >>> Ayush Jain @ jainayus...@gmail.com >>> <><><><><><><><><><><><><><><><><><><><><><> >>> HELP US GROW !! >>> >>> We reach over 6,500 subscribers worldwide and receive many nice notes >>> about the learning and support from the group.Let friends and co-workers >>> know they can subscribe to group at >>> http://groups.google.com/group/excel-macros/subscribe >>> >>> >> >> -- >> >> ---------------------------------------------------------------------------------- >> Some important links for excel users: >> 1. Follow us in TWITTER for tips tricks and links : >> http://twitter.com/exceldailytip >> 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at >> http://www.excelitems.com >> 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 >> If you find any spam message in the group, please send an email to: >> Ayush Jain @ jainayus...@gmail.com >> <><><><><><><><><><><><><><><><><><><><><><> >> HELP US GROW !! >> >> We reach over 6,500 subscribers worldwide and receive many nice notes >> about the learning and support from the group.Let friends and co-workers >> know they can subscribe to group at >> http://groups.google.com/group/excel-macros/subscribe >> >> > > -- > > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us in TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 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 > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the learning and support from the group.Let friends and co-workers know they > can subscribe to group at > http://groups.google.com/group/excel-macros/subscribe > >
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 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 If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
