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+their corr. values by DILipandey.xls
Description: MS-Excel spreadsheet
