Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using data from multiple worksheets in a formula
I have a workbook that will have 26 worksheets, the first worksheet will
serve as an index of data for a roster of students. The other worksheets will be divided by individual teachers. I need a formula that will search all the 25 worksheets for an individual student, then average the data for each student. I tried VLOOKUP but it will not give an average of let say 6 sets of data or scores from the 25 sheets. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using data from multiple worksheets in a formula
Let me suggest a fundamental change in the structure of your file. Put ALL
the data in a single worksheet, with one additional column specifying the teacher. Then use Excel's built-in sorting and filtering to view, analyze, and report on that data. Much easier approach "altschool" wrote: I have a workbook that will have 26 worksheets, the first worksheet will serve as an index of data for a roster of students. The other worksheets will be divided by individual teachers. I need a formula that will search all the 25 worksheets for an individual student, then average the data for each student. I tried VLOOKUP but it will not give an average of let say 6 sets of data or scores from the 25 sheets. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula with multiple worksheets | Excel Worksheet Functions | |||
Formula help for multiple worksheets | Excel Discussion (Misc queries) | |||
Formula Referencing data on multiple worksheets | Excel Worksheet Functions | |||
How do i update multiple data ranges across multiple worksheets? | Excel Discussion (Misc queries) | |||
same data multiple worksheets | Excel Discussion (Misc queries) |