Re: $$Excel-Macros$$ Re:Help to find position of a particular number in a given data set

2012-03-21 Thread dguillett1
Sounds like homework Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Atul Patel Sent: Tuesday, March 20, 2012 4:24 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re:Help to find position of a particular number in a given data set Hi, I need

$$Excel-Macros$$ Re:Help to find position of a particular number in a given data set

2012-03-21 Thread Atul Patel
Hi, I need help to find position of a particular number in a given data set. Please refer to the table below. Fin. Inst. Rates in % A 10 B 11 C 12 D 11 E 6 F 9 G 8 H 8 I 9 J 7 In the above example, Rates are given for each financial institution. In descending order,the rate 12% is