hi atul check the attached file , which has unique rank in ascending and descending way... i think you will get more option in your list for ranking
On 27/01/2010, ayush jain <jainayus...@gmail.com> wrote: > Dear Atul, > > Attached is the solution for unique rank. Let us know if you need any > further help. > > Best regards, > Ayush Jain > [Group Owner] > > On Wed, Jan 27, 2010 at 10:15 AM, Atul <atul_pate...@yahoo.com> wrote: > >> Hi Dilip and Ayush, >> >> Thanks for responding quickly with the solution. As per the solution >> on the attached, Rank 4 has been assigned to G. While assigning rank >> to the Rates (not Financial Institutions) in descending order, the >> rate of 1.75% is the third one from the top. >> >> The Rank function does not ignore multiple occurrences and assign >> subsequent Rank. Please refer to the Ayush's solution. There are two >> instances of Rate 2.0% (with rank 2). For the next rate (in decending >> order) of 1.75% which is third in place, has been assigned rank 4 >> instead of Rank 3 >> >> Your futher help or guidance is much appreciated ! >> >> Thanks once again >> >> Atul >> >> >> >> On Jan 26, 12:52 pm, Dilip Pandey <dilipan...@gmail.com> wrote: >> > Dear Atul, >> > >> > Please find the attached solution. >> > >> > Best Regards, >> > -- >> > DILIP KUMAR PANDEY >> > MBA-HR,B COM(Hons.),BCA >> > Mobile: +91 9810929744 >> > dilipan...@gmail.com >> > dilipan...@yahoo.com >> > New Delhi - 110062 >> > >> > On 1/26/10, Atul <atul_pate...@yahoo.com> wrote: >> > >> > > Hi, >> > >> > > Following is the list of financial Institution with interest rates. I >> > > need to assign Rank to the interest rate for specific Fin. Inst the >> > > highest rate being rank 1, any multiple occurrences should be assighed >> > > the same rank. >> > >> > > Financial Interest RANK >> > > Institution Rate >> > > A 1.25 >> > > B 2.00 2 >> > > C 1.25 >> > > D 1.50 >> > > E 1.50 >> > > F 1.00 >> > > G 1.75 3 >> > > H 2.00 2 >> > > I 2.25 1 >> > > J 1.60 >> > > K 1.70 4 >> > >> > > Rank >> > > Inst.G 4 >> > >> > > Link for book 2 ( I could not attach the file) >> > >http://groups.google.com/group/excel-macros/web/Book2.xlsx >> > >> > > -- >> > >> > > >> ---------------------------------------------------------------------------------- >> > > 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 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 >> > > 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 >> > >> > >> > >> > Assigning Rank - by DILipandey.xls >> > 33KViewDownload >> >> -- >> >> ---------------------------------------------------------------------------------- >> 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 > -- Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- ---------------------------------------------------------------------------------- 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
Unique_rank_Solved by ankur.xls
Description: MS-Excel spreadsheet
