Hi Dilip, Your formula Works fine only if the duplicate sales are continuos . if the duplicate sales are not continuos then it is not working . for example in the attached excel file there is a scenario in which it does nt work .
On Sun, Feb 7, 2010 at 10:00 PM, Dilip Pandey <dilipan...@gmail.com> wrote: > You are always welcome Vimal...!! > > -- > 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: >> >> 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
Top_Volume.xls
Description: MS-Excel spreadsheet
