Thanks Micky and Jacob.... Both methods worked pretty well...

Again Thanks a lot.....
--
Karthi


"מיכאל (מיקי) אבידן" wrote:

In your(!) Individual/Private case you may:
In cell F1: =LARGE($B$1:$B$8,ROW()) and copy down.
In cell E1: ="User "&MATCH(F1,$B$1:$B$8,) and copy down.
Micky


"Karthik" wrote:

Hi All,

I've a data from Col A to Col C, Column A contains names and column B
contains Quantily. I've used Rank condition in column C.

I want a formula to return names of top five in column F and quantity in
column G

A B C D E F

User 1 10 4 User 3 20
User 2 5 7 User 7 14
User 3 20 1 User 6 11
User 4 6 6 User 1 10
User 5 7 5 User 5 7
User 6 11 3
User 7 14 2
User 8 3 8

I can use Vlookup to get details in column F but would need help in finding
a formula to get Column E.

Thanks.
--
Karthi