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