+ Reply to Thread
Results 1 to 4 of 4

Automatically Generated Average Sheet

  1. #1
    Registered User
    Join Date
    11-22-2007
    Posts
    42

    Automatically Generated Average Sheet

    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!

  2. #2
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    You could copy them all to one sheet, then sort them based on name, and then subtotal using average (see attached). This can be done if VBA, but you would need to be more specific (i.e. attach a sample spreadsheet).

    Jason
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-22-2007
    Posts
    42

    Thanks. Wow

    Hi Jason,

    That is exactly what I want!

    Easier than I thought it would be. Thankyou so much!

  4. #4
    Forum Expert
    Join Date
    12-29-2004
    Location
    Michigan, USA
    MS-Off Ver
    2013
    Posts
    2,208
    Glad to help, ugg.

    Jason

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1