Results 1 to 3 of 3
  1. #1
    New Lounger
    Join Date
    Mar 2016
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    spreadsheet merge/report question

    I have a spreadsheet with student data that I want to create reports that show students who scored below a threshold. The spreadsheet is in Excel and is set up with student names in A. Skills are listed on the top row, and student scores across. I trying to make 2 different reports. The first would list the skill, then the students who scored below 70% listed below. The second I would like to have the student name with the skills they scored below 70% under.

    Report 1:

    Main Idea
    John
    Susie
    Frank
    Paul

    Characterization
    John
    Susie
    Jane


    Report 2:

    John
    Main Idea
    Characterization
    Inference

    Is this possible using Excel & Word? Thanks!

  2. #2
    Super Moderator
    Join Date
    May 2002
    Location
    Canberra, Australian Capital Territory, Australia
    Posts
    5,054
    Thanks
    2
    Thanked 417 Times in 346 Posts
    Depending on how your data are organized, you could do that using a mailmerge in Word or with DATABASE fields in Word.
    Cheers,

    Paul Edstein
    [MS MVP - Word]

  3. #3
    Bronze Lounger
    Join Date
    Jan 2001
    Location
    La Jolla, CA
    Posts
    1,470
    Thanks
    30
    Thanked 62 Times in 58 Posts
    Welcome to the lounge.

    A mail merge as Paul suggested is a good idea. I played w/it and came up with the two reports on two separate sheets what would require you to filter the columns for each student. Just another idea.
    Attached Files Attached Files

Posting Permissions

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