Results 1 to 6 of 6

Thread: Need a Report Calculating Across Multiple Columns from Different Worksheets

  1. #1

    Need a Report Calculating Across Multiple Columns from Different Worksheets



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I just submitted this in the "Charts" thread but thought it might be more appropriate here.

    In my workbook, I have four worksheets that I am trying to work through the following problem. Those sheets are "Stakeholder Roster", "County Roles", "Agency List" and "Roles By Agency Count".

    "Stakeholder Roster" contains column with about 1100 employees within 30 Agencies. There are then 20 columns for which each row/stakeholder can be assign multiple roles from a drop-down list of ~65 roles.

    In the sheet "Roles By Agency Count", the Agency list is in column B; the 65 roles are across row 2. On this worksheet, I want to have the intersection of an Agency and a Role tell me how many times a role was assigned within a particular Agency in the "Stakeholder Roster" sheet. The challenge is that in the "Stakeholder Roster" sheet, the same role may appear in various columns (i.e., role X is not always listed down one column for all users; user 1 may have role # in column L while user 2 may have role # assigned in column P)..

    I will gladly share the file with anyone who would like to see it for more context.

  2. #2
    Share file if you find Excel 2010/2013 PowerPivot acceptable.

  3. #3

    Attached File

    The file is 853K so the system will not let me upload. Can we do something via email?


    Quote Originally Posted by Herbds7 View Post
    Share file if you find Excel 2010/2013 PowerPivot acceptable.

  4. #4
    MediaFire.com is free and accepts MB.
    Or use any other file sharing site and post link.
    ExcelGuru is a public forum for all to learn and share.

  5. #5

    Link to file

    Here is a link to the file

    http://www.mediafire.com/view/p2txiw...21_-_TEST.xlsx

    Quote Originally Posted by Herbds7 View Post
    Share file if you find Excel 2010/2013 PowerPivot acceptable.

  6. #6
    Excel 2010 Tables, PivotTables
    No formulas or code needed or used.
    With simplified format, generic data and reduced size (35KB)
    http://www.mediafire.com/view/595ixo...05_23_14b.xlsx

Posting Permissions

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