Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combing Student list and Classes they took to one sheet
This is the last step I have in a larger project. Any help would be
appreciated. A sample workbook is attached with a desired results tab. In one sheet (List of People): I have a list of Student Names and each grade level they attended while at my school. In another sheet (Class Breakdown): I have a list of the kids and the classes they took. One can assume that for the Students that were there for more than one year, they took the same breakdown of classes each year [the Class Breakdown sheet contains no year information, only student and class]. For each entry in 'List of People' I need unique lines for each project that person took. So for example: in 'Class Breakdown' Amanda has taken 4 classes: Math, Philosophy, English, and French. In 'List of People' I have that Amanda went here for 3 years Code: Freshman Amanda Sophomore Amanda Junior Amanda So I would then need the results page to show Code: Freshman Amanda Math Freshman Amanda Philosophy Freshman Amanda English Freshman Amanda French Sophomore Amanda Math Sophomore Amanda Philosophy Sophomore Amanda English Sophomore Amanda French Junior Amanda Math Junior Amanda Philosophy Junior Amanda English Junior Amanda French Any help would be appreciated. It is important to note, that there will also be numbers in the columns to the right of this information (hense the random data in the sample spreadsheet). URL to post at ExcelForum (no one has been able to help me yet over there): http://www.excelforum.com/excel-prog...one-sheet.html Sample file at: http://www.mediafire.com/?1mf3fzz3qyw |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Combing Student list and Classes they took to one sheet
On Jul 12, 2:54*pm, Chase wrote:
This is the last step I have in a larger project. Any help would be appreciated. A sample workbook is attached with a desired results tab. In one sheet (List of People): I have a list of Student Names and each grade level they attended while at my school. In another sheet (Class Breakdown): I have a list of the kids and the classes they took. One can assume that for the Students that were there for more than one year, they took the same breakdown of classes each year [the Class Breakdown sheet contains no year information, only student and class]. For each entry in 'List of People' I need unique lines for each project that person took. So for example: in 'Class Breakdown' Amanda has taken 4 classes: Math, Philosophy, English, and French. In 'List of People' I have that Amanda went here for 3 years Code: Freshman * * * *Amanda Sophomore * * * Amanda Junior * * * * *Amanda So I would then need the results page to show Code: Freshman * * * *Amanda * * * * Math Freshman * * * *Amanda * * * * Philosophy Freshman * * * *Amanda * * * * English Freshman * * * *Amanda * * * * French Sophomore * * * Amanda * * * * Math Sophomore * * * Amanda * * * * Philosophy Sophomore * * * Amanda * * * * English Sophomore * * * Amanda * * * * French Junior * * * * *Amanda * * * * Math Junior * * * * *Amanda * * * * Philosophy Junior * * * * *Amanda * * * * English Junior * * * * *Amanda * * * * French Any help would be appreciated. It is important to note, that there will also be numbers in the columns to the right of this information (hense the random data in the sample spreadsheet). URL to post at ExcelForum (no one has been able to help me yet over there):http://www.excelforum.com/excel-prog...ing-student-li... Sample file at:http://www.mediafire.com/?1mf3fzz3qyw On the classes sheet, insert col A and use this or a macro =INDEX('List of People'!A:A,MATCH(B2,'List of People'!B:B,0)) "If desired, send your file to dguillett @gmail.com I will only look if: 1. You send a copy of this message on an inserted sheet 2. You give me the newsgroup and the subject line 3. You send a clear explanation of what you want 4. You send before/after examples and expected results." |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
trying to get sheet 1 to recognize and move student names to pg 2 | Excel Worksheet Functions | |||
Is there an updated 2009-2010 student attendance sheet? (template) | Excel Discussion (Misc queries) | |||
Calling Classes from Classes | Excel Programming | |||
Automation Classes / Methods, overview or list | Excel Discussion (Misc queries) | |||
Student Absentee List help please | Excel Programming |