Dear Dew, Rank is already starting from 1. Please check and revert with some more details. Thanks.
Best Regards, DILIPandey On 5/20/11, dewbro2 <kdew...@brownmre.com> wrote: > How can I make this rank start with 1 instead of zero. > > On Jul 7 2010, 2:41 am, Dilip Pandey <dilipan...@gmail.com> wrote: >> HI Subbu, >> >> I hope you have found the solution for this query. >> Recently I came across a similar kind of query and after solving that I >> have >> customized the solution to solve your query. Please find the attached >> solution and let me know if this helps. 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 Wed, May 19, 2010 at 5:01 PM, subs <subbu1...@gmail.com> wrote: >> > ocity ostate carrier price >> > a b X 1200 >> > a b Y 1290 >> > c d X 1300 >> > c d Z 1500 >> > e f R 129 >> >> > i want to add another column to the above spreadsheet called as rank >> > which basically ranks every lane(ocity and dcity) based on price(in >> > the ascending order). for example the output should be as follows >> >> > ocity ostate carrier price rank >> >> > a b X 1200 1 >> > a b Y 1290 2 >> > c d X 1300 1 >> > c d Z 1500 2 >> > e f R 129 1 >> >> > what is the formula to create the column rank in exel . help is >> > appreciated >> >> > -- >> >> > ---------------------------------------------------------------------------------- >> > 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 athttp://www.excel-macros.blogspot.com >> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com >> > 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com >> >> > To post to this group, send email to excel-macros@googlegroups.com >> >> > <><><><><><><><><><><><><><><><><><><><><><> >> > HELP US GROW !! >> >> > We reach over 6,800 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 >> >> >> >> Rank or Sort by DiLipandey.xls >> 27KViewDownload- Hide quoted text - >> >> - Show quoted text - > -- Thanks & Regards, DILIP KUMAR PANDEY, mvp MBA,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 <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
