| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Help with LARGE formula with multiple worksheets
Hello all. Please help me with a problem I am having. I have set up a
spreadsheet with 11 worksheets for keeping scores of 10 different events. Sheets 1-10 are scores for individual events. Sheet 11 is a list that keeps track of the top 3 in each category. The indivual sheets have 5 columns. Column A is the school name, B-D are sub scores and E is a total score. The winner's list has 3 columns, A is the event, B needs to be the school name and C is the score. I have used the LARGE formula to pull over the top 3 scores into Column C, but I need to find out how to pull over the corresponding school name. Please help. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Sort rows across multiple worksheets - Excel 2003 | Excel Worksheet Functions | |||
| apply cell names to formulas in multiple worksheets | Excel Worksheet Functions | |||
| Extracting data from multiple worksheets into a list | Excel Worksheet Functions | |||
| Updating multiple worksheets in a large workbook | Excel Discussion (Misc queries) | |||
| Excel should let me refer to the same formula on multiple sheets | Excel Worksheet Functions | |||
Threaded Mode
