Hi,
Try this. Assume that your data is in range B3:D13 (including the header
row say Name, Percentage and Result). In E16:F16, enter Result and
Condition. In E17, enter Pass and in F17 enter =RANK(C4,$C$4:$C$13)<=5. On
B21, type Name
Now go to Data filter Advanced Filter. Select copy to another location
and in the list range, select B3:D13. In the criteria range, select
E16:F17. In the copy to box, select cell B21 and now click on OK.
Hope this helps
--
Regards,
Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com
"Vikram" wrote in message
...
I have a sorted data of 450 learners with name and percentage. Columns are
Name Percentage Result
Mac 86 Pass
Richard 67 Fail
Jack 91 Fail
.....
I need a seperate list of TOP 5 LEARNERS with name columns.
I have tried Pivote table and Large function but it dont work as I can
filter on numeric values (as top 10) but i need top 5 and that too top 5
names alone.
NOTE:Topper Name List should not contain Fail students even if they have
top
marks.
Please help asap.
Regards
Vikram