Re: $$Excel-Macros$$ How to assign rank from the list

2010-01-27 Thread Dilip Pandey
Dear Atul, You have the revised spreadsheet, thanks to Ayush. Please confirm if your requirements are met. Best Regards, -- DILIP KUMAR PANDEY MBA-HR,B COM(Hons.),BCA Mobile: +91 9810929744 dilipan...@gmail.com dilipan...@yahoo.com New Delhi - 110062 On Wed, Jan 27, 2010 at 10:15 AM, Atul

Re: $$Excel-Macros$$ How to assign rank from the list

2010-01-26 Thread ankur
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 wrote: > Dear Atul, > > Attached is the solution for unique rank. Let us know if you need any > further help. > > Best re

Re: $$Excel-Macros$$ How to assign rank from the list

2010-01-26 Thread ayush jain
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 wrote: > Hi Dilip and Ayush, > > Thanks for responding quickly with the solution. As per the solution > on the attached,

Re: $$Excel-Macros$$ How to assign rank from the list

2010-01-26 Thread Atul
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

Re: $$Excel-Macros$$ How to assign rank from the list

2010-01-26 Thread Dilip Pandey
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 wrote: > > Hi, > > Following is the list of financial Institution with interest rat

Re: $$Excel-Macros$$ How to assign rank from the list

2010-01-25 Thread ayush jain
Dear Atul, Use Rank formula for ranking of data. Attached is the solution for you. Let us know if further help is required. Best regards, Ayush Jain Group Owner On Tue, Jan 26, 2010 at 10:00 AM, Atul wrote: > Hi, > > Following is the list of financial Institution with interest rates. I > need

$$Excel-Macros$$ How to assign rank from the list

2010-01-25 Thread Atul
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