| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Need help in Excel 2007 - urgent
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 |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
Need help in Excel 2007 - urgent
MikeH gave help he
http://www.microsoft.com/office/comm...8-c64054968ac9 "Vikram" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Urgent: Excel 2003 - 2007 conflict! | Excel Discussion (Misc queries) | |||
| Urgent! Help needed for Excel | Excel Discussion (Misc queries) | |||
| IME MODE FOR EXCEL 2007 (URGENT URGENT) | Excel Discussion (Misc queries) | |||
| Urgent! How do I create mailing labels with Excel 2007? | Excel Discussion (Misc queries) | |||
| Urgent-Urgent VBA LOOP | Excel Discussion (Misc queries) | |||
Linear Mode
