Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding the top two in a multi page workbook
How do I find the top two numbers in a multipage workbook and link it to
another cell. Example workbook page 1 workbook page 2 student1 500 student9 150 student2 600 student7 1400 student3 450 student6 300 I need it to find the top two numbers of the two workbook pages and and list the students name.I used the function below, but can't figure out how to use multiple classes and still get the name to show not the numbers itself. =INDEX('PM Kinder'!A5:A19,MATCH(MAX('PM Kinder'!C5:C19 ),'PM Kinder'!C5:C19,0)) Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I e-mail 1 page of a multi page workbook | Excel Discussion (Misc queries) | |||
Complex Multi-condition, multi-workbook count | Excel Discussion (Misc queries) | |||
How can I use a VLOOKUP function to search a multi-page workbook? | Excel Worksheet Functions | |||
How can I use a VLOOKUP function to search a multi-page workbook? | Excel Worksheet Functions | |||
Get header only on first page of multi page excel file | Excel Discussion (Misc queries) |