Good morning,
Firstly let me say, I am new to this but finding out exciting things all the time. Hopefully this will be the same
I would like to have a new spreadsheet list and calculate an average based on other worksheets in the spreadsheet.
Example:
Worksheet 1 Sample
Column Names: Name | Score | Date
Row Data: John Smith | 92 | 5/01/2007 4:00:28 PM
Row Data: Jane Smith | 86 | 5/01/2007 3:18:03 PM
Worksheet 2 Sample
Column Names: Name|Score|Date
Row Data: John Smith | 93 | 6/01/2007 1:38:38 PM
Row Data: Jane Smith | 56 | 4/01/2007 3:20:01 PM
Is there anyway that I can run * Something * that will create a new sheet that will list each entry for John Smith and then calculate his average score (I am fine with the average formula, more the listing and etc). Please see below.
Worksheet 3 Example
Column Names: Name | Score | Date
Row Data: John Smith | 92 | 5/01/2007 4:00:28 PM
Row Data: John Smith | 93 | 6/01/2007 1:38:38 PM
+ Row Data: John Smith Average | 92.5 |
Row Data: Jane Smith | 86 | 5/01/2007 3:18:03 PM
Row Data: Jane Smith | 56 | 4/01/2007 3:20:01 PM
+ Row Data: Jane Smith Average | 71 |
I have a whole stack of names and this would save a heck of a lot of work!
Thanks for looking!
Bookmarks