Generate dynamic lists from other tables in Numbers

Discussion in 'iWork Forum' started by Rwpreed, Aug 2, 2012.

  1. Rwpreed

    Expand Collapse
    iPF Noob

    Aug 2, 2012
    Thanks Received:
    How do I Generate dynamic lists from other tables in Numbers

    I'm asking for help, not giving directions. I forgot the ?mark.

    I'm a teacher, and I would like a table that looks up the grade achievement for my students, and sorts them into groups based on their scores. The idea is to save me time by generating the lists of students who need extra help with a particular skill or subject, rather than me having to go through a table of scores for 20 kids with marks in 20 different skill sets (math in particular) manually.

    This is a very simplified example of what I'd like it to do.

    Student scores
    Student name - bob - mary - joe
    Math score ------d------d------a
    Reading score---a------b------a

    Students grouped by grade level
    Grade level------A--------B-------C---------D
    Math groups----Joe-----none---none---bob, mary
    Reading grp--bob,joe-- mary---none----none

    I'd like to be able to do this so that all I have to do is change the data in table 1 and it will automatically update the lists in table two, so that if bob goes from d to c his name will move from the D column in math to the C column.

    I was able to something like this with a column of checklists paired with list words that concatenated all the words that were left unchecked, but I needed 42 separate if statements, and it only dealt with t/f, but this new challenge obviously deals with 4 possible outcomes per student.

    Hope you can help. Thanks in advance.

    #1 Rwpreed, Aug 2, 2012
    Last edited: Aug 3, 2012

Share This Page

Search tags for this page
automatically generate tables in apple numbers
create a dynamic table in osx numbers
dynamic ipad
dynamic material list in iwork numbers
dynamic tables

how to create dynamic list in numbers in mac

how to create dynamic list in numbers ipad

numbers dynamic tables

pivot table in numbers ipad
pivot tables in numbers for ipad