Thanks a lot . this is exactly wat i wanted . you saved my lot of manual time . thanks a ton .
Cheers, Vimal Barlota On Sun, Feb 7, 2010 at 8:53 PM, Dilip Pandey <dilipan...@gmail.com> wrote: > Dear Vimal, > > Attached file has been formulated as per your requirement(s). > Get back to me in case of any queries. > > 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 2/7/10, vimal barlota <vimalbarl...@gmail.com> wrote: >> >> Hello Dilip, >> >> Thanks a lot for taking time to answer my query .. i have another >> question . hope i am not asking too much..after getting the top ten sales i >> need to get their corresponding volume and pid . i can do this by using >> index and match formula. but how to find volumes when the sales are same >> ..for example if the data is like shown below : >> >> pid Volume Sales >> 1 1.13 2423 >> 2 1.5 32423 >> 3 2.92 3243 >> 4 1.47 3243 >> 5 1.49 3243 >> >> >> After getting the top ten sales how do i find their corresponding volume >> and pid . >> if you could provide a formula for this it wil be really helpful . >> >> Cheers, >> Vimal Barlota >> >> >> On Sat, Feb 6, 2010 at 8:19 PM, Dilip Pandey <dilipan...@gmail.com>wrote: >> >>> Dear Vicky, >>> >>> Solution is attached containing your scenario. >>> Revert back in case of any queries. >>> >>> Best Regards >>> -- >>> DILIP KUMAR PANDEY >>> MBA-HR,B Com(Hons.),BCA >>> Mobile: +91 9810929744 >>> dilipan...@gmail.com >>> dilipan...@yahoo.com >>> New Delhi - 62, India >>> >>> >>> On 2/3/10, vicky <vimalbarl...@gmail.com> wrote: >>>> >>>> volume sales >>>> 1.13 2423 >>>> 1.5 32423 >>>> 2.92 33243 >>>> 1.47 3243 >>>> 1.49 234234 >>>> 1.35 343423 >>>> 3.45 32423 >>>> >>>> >>>> i need top ten sales values for volume > 1 and volume < 2 >>>> >>>> -- >>>> >>>> ---------------------------------------------------------------------------------- >>>> Some important links for excel users: >>>> 1. Follow us on 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,700 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 on 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,700 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
