Welcome to iPadForums.net Guest - Click Here to Register

Generate dynamic lists from other tables in Numbers

This is a discussion on Generate dynamic lists from other tables in Numbers within the iWork Forum forums, part of the iPad App Store category; I'm asking for help, not giving directions. I forgot the ?mark. Hello I'm a teacher, and I would like a table that looks up the ...

iPadForums.net is the original Apple iPad Forum! Registered Users do not see these ads. Please Register - It's Free!
+ Reply to Thread
Results 1 to 1 of 1
  1. #1
    iPF Noob
    Member #
    233225
    Join Date
    Aug 2012
    Posts
    1

    How do I Generate dynamic lists from other tables in Numbers

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

    Hello
    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.

    Roy
    Last edited by Rwpreed; 08-03-2012 at 09:05 PM.

  2. Ads



Home | Forum | Active Topics | What's New

Links

Posting Permissions

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

Similar Threads

  1. Generate Barcode from Word
    By aframiller326 in forum iPad for Business and Education
    Replies: 11
    Last Post: 05-16-2013, 07:36 AM
  2. iPad Numbers Forms & sales lists
    By hawtin in forum iPad at Work
    Replies: 1
    Last Post: 04-08-2012, 04:57 AM
  3. Tables from Numbers and Excel sheets
    By rndoliveira in forum iPad General Discussions
    Replies: 1
    Last Post: 01-02-2012, 06:39 PM
  4. Pivot Tables in Numbers?
    By daker in forum iWork Forum
    Replies: 3
    Last Post: 08-21-2011, 12:55 AM
  5. Generate Dynamic Images Inside Ipad Split View Controller
    By rickjackson in forum iPad Development
    Replies: 1
    Last Post: 04-07-2011, 01:34 AM

Search tags for this page

create a dynamic list in apple numbers
,
dynamic list data list apple ipad numbers
,
ipad numbers generate dynamic list from other tables
,

ipad numbers pivot table

,
iwork dynamic table
,
mac numbers dynamic table
,

numbers dynamic tables

,
pivot tables numbers ipad
Click on a term to search for related topics.