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 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 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
