You are welcome..Kalyan. I have used the array functionallity to grasp the desired results and given you two drop downs, which you can utilize for your desired result selection. You can also add more drop downs as per your interest in the similar fashion.
I would recommend you to learn some material over internet to know about the ARRAY functionality. Let me know if you have any challenges. Thanks. -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India On Mon, Aug 23, 2010 at 2:09 PM, Kal xcel <kalx...@gmail.com> wrote: > Dear Dilip, > > Thank u very much for solving my problem, could you please make me > understand the logic. > > Thanks once again > > Kalyan > > On Sat, Aug 21, 2010 at 11:27 AM, Dilip Pandey <dilipan...@gmail.com>wrote: > >> HI Kalyan, >> >> Please see the attached file, wherein I have given you the option to >> select more then one Distributor. Let me know if this solves >> >> -- >> Thanks & Regards, >> >> DILIP KUMAR PANDEY >> MBA-HR,B.Com(Hons),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 62, India >> >> On Thu, Aug 19, 2010 at 12:33 PM, Kal xcel <kalx...@gmail.com> wrote: >> > >> > Dear Dilip, >> > >> > I am attaching a file where I have raw data of Depot, Customer group, >> Month and Sales data. There are 16 types of customer group. I need depot >> wise month wise & Distributor+Super stockist wise(customer group) sale data. >> > >> > I tried with sumifs & sumproduct formula, but it's not working properly. >> > >> > Pivot table is not my required solution. >> > >> > Thanks in advance >> > >> > Kalyan >> > >> > -- >> > >> ---------------------------------------------------------------------------------- >> > 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 >> > >> > <><><><><><><><><><><><><><><><><><><><><><> >> > HELP US GROW !! >> > >> > We reach over 7000 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 >> > >> >> >> >> -- >> Thanks & Regards, >> >> DILIP KUMAR PANDEY >> MBA-HR,B.Com(Hons),BCA >> Mobile: +91 9810929744 >> dilipan...@gmail.com >> dilipan...@yahoo.com >> New Delhi - 62, India >> > > -- Thanks & Regards, DILIP KUMAR PANDEY MBA-HR,B.Com(Hons),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 62, India -- ---------------------------------------------------------------------------------- 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 <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 7000 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
