Finding row number of top 3 entries

**Amar Thakkar** · 10-10-2011, 07:53 AM

My data file is in the attached format

Using VBA, I need the row numbers of all the companys with top 3 EBITDA.

**tom1977** · 10-10-2011, 08:32 AM

try this

Please Login or Register  to view this content.

**6StringJazzer** · 10-10-2011, 08:39 AM

Any particular reason why it needs to be VBA? Are you using the list of row numbers in other code?

If you just need to display the data here is a non-VBA solution.

**Amar Thakkar** · 10-21-2011, 01:19 AM

Originally Posted by 6StringJazzer

Any particular reason why it needs to be VBA? Are you using the list of row numbers in other code?

If you just need to display the data here is a non-VBA solution.

Sorry for not responding for so long..
I had to shelve that part of the project so I have not tried out the solutions provided by you guys..

thanks for helping ..