Results 1 to 4 of 4

Creating a list from a table

Threaded View

IsuckatXL Creating a list from a table 02-23-2018, 09:10 PM
samba_ravi Re: Creating a list from a... 02-23-2018, 09:50 PM
IsuckatXL Re: Creating a list from a... 02-23-2018, 10:07 PM
MarvinP Re: Creating a list from a... 02-23-2018, 10:19 PM
  1. #1
    Registered User
    Join Date
    02-23-2018
    Location
    England
    MS-Off Ver
    2016
    Posts
    2

    Creating a list from a table

    Hi guys,

    I'm trying to use excel to analyse my students results in an exam paper. I have split the paper into 26 different sections and have put the childrens scores onto the spreadsheet. It has the childrens names on the left and the amount of marks the got for each questions as a decimal proportion of the available grades.

    I want to create a list of students that got 100% of the marks and a list of those that got 0%.

    EG - What I have at the moment


    Name Q1 Q2 Q3 Q4 Q5 Q6
    Kid 1 1 0 0.5 1 1 0
    Kid 2 0 0 1 0.5 1 1

    What I would like

    Q1 Q2 Q3 Q4 Q5 Q6
    Kid 1 Kid 2 Kid 1 Kid 1 Kid 2
    Kid 2

    Q1 Q2 Q3 Q4 Q5 Q6
    Kid 2 Kid 1 Kid 1
    Kid 2


    Hopefully this makes some kind of sense!

    If anyone could help, you'd be making a very sleep deprived teacher very happy!

    Thanks!
    Attached Files Attached Files
    Last edited by IsuckatXL; 02-23-2018 at 09:21 PM. Reason: formatting

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Creating a list from a questionnaire table
    By Tpiper1 in forum Excel General
    Replies: 3
    Last Post: 05-23-2016, 10:11 AM
  2. [SOLVED] Creating List from Table
    By trandle in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 09-21-2014, 10:47 PM
  3. Replies: 9
    Last Post: 02-26-2014, 04:17 PM
  4. Need Help Creating a Table List
    By 4747daniellel in forum Excel General
    Replies: 6
    Last Post: 10-19-2011, 07:33 AM
  5. Need Help Creating a Table List
    By 4747daniellel in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-19-2011, 03:56 AM
  6. Creating a list from a large table
    By davidmarlow in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 11-23-2009, 05:37 AM
  7. creating a list from a table
    By sss.seg in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-17-2009, 12:52 PM

Tags for this Thread

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