+ Reply to Thread
Results 1 to 4 of 4

Help with comparison chart / pivot table

  1. #1
    Registered User
    Join Date
    03-14-2011
    Location
    usa
    MS-Off Ver
    Excel 2003
    Posts
    2

    Help with comparison chart / pivot table

    Hi all,

    This is driving me crazy. Using Excel 2003.

    - I have a list of students that have completed some training courses and I am trying to put together a pivot table or comparison sheet that shows which which classes are "completed" and which classes are still "required".

    - The data that I have is four (4) columns -
    "Lastname" "Firstname" "Name of Class Completed" "Name of Class Required"

    Thanks in advance!

    Corey

  2. #2
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Help with comparison chart / pivot table

    Hello, can you please upload a data sample in an Excel workbook and explain what you would like to see as the result of the pivot table?

  3. #3
    Registered User
    Join Date
    03-14-2011
    Location
    usa
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Help with comparison chart / pivot table

    Thank you for the response. I have uploaded a sample as an attachment.

    Basically, the part in pink is the data that I have to work with.

    The Pivot Table on the left is what I have been able to accomplish.

    I want to be able to add the data that is in red to the pivot table as a seperate column so that I can see which courses the students have not taken.

    I hope this makes sense, its kind of hard to articulate.

    Thanks again!
    Corey
    Attached Files Attached Files

  4. #4
    Forum Guru teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,364

    Re: Help with comparison chart / pivot table

    Hello,

    You'd have to re-arrange your source data to create a pivot table with all courses. Include all courses per name, then use a column to indicate if they have been completed or not. See attached

    cheers
    Attached Files Attached Files

+ 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