DentonHTHS
New Member
- Joined
- Jul 3, 2008
- Messages
- 39
Hi everyone, I have a sample file of the work I am trying to do with a much larger file. Basically, I would like the second tab to automatically pull the data from the first tab. On tab 2, I will have the column of student names but would like to have the number of courses they are failing and the name of the course(s) listed out on the same line. On the first tab, the number "1" indicates that the student is taking the course and is failing.
Any help would be greatly appreciated.
DentonHTHS
Tab 1
[TABLE="width: 500"]
<tbody>[TR]
[TD]Student[/TD]
[TD]Course 1[/TD]
[TD]Course 2[/TD]
[TD]Course 3[/TD]
[TD]Course 4[/TD]
[TD]Course 5[/TD]
[/TR]
[TR]
[TD]Bruce Wayne[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Hal Jordan[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Barry Allen[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Diana Prince[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Clark Kent[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Tab 2
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Student[/TD]
[TD]# Courses Failing[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Bruce Wayne[/TD]
[TD]3[/TD]
[TD]Course 1[/TD]
[TD]Course 3[/TD]
[TD]Course 5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hal Jordan[/TD]
[TD]3[/TD]
[TD]Course 1[/TD]
[TD]Course 3[/TD]
[TD]Course 4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Barry Allen[/TD]
[TD]2[/TD]
[TD]Course 3[/TD]
[TD]Course 5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Diana Prince[/TD]
[TD]1[/TD]
[TD]Course 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Clark Kent[/TD]
[TD]2[/TD]
[TD]Course 1[/TD]
[TD]Course 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I need formulas that will insert the names of the courses each student has failed in the spaces in Columns C-G and total the amount failed in Column B pulling the data from Tab 1
Any help would be greatly appreciated.
DentonHTHS
Tab 1
[TABLE="width: 500"]
<tbody>[TR]
[TD]Student[/TD]
[TD]Course 1[/TD]
[TD]Course 2[/TD]
[TD]Course 3[/TD]
[TD]Course 4[/TD]
[TD]Course 5[/TD]
[/TR]
[TR]
[TD]Bruce Wayne[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Hal Jordan[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD]1[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Barry Allen[/TD]
[TD][/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Diana Prince[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Clark Kent[/TD]
[TD]1[/TD]
[TD][/TD]
[TD]1[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
Tab 2
[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Student[/TD]
[TD]# Courses Failing[/TD]
[TD]1[/TD]
[TD]2[/TD]
[TD]3[/TD]
[TD]4[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD]Bruce Wayne[/TD]
[TD]3[/TD]
[TD]Course 1[/TD]
[TD]Course 3[/TD]
[TD]Course 5[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Hal Jordan[/TD]
[TD]3[/TD]
[TD]Course 1[/TD]
[TD]Course 3[/TD]
[TD]Course 4[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Barry Allen[/TD]
[TD]2[/TD]
[TD]Course 3[/TD]
[TD]Course 5[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Diana Prince[/TD]
[TD]1[/TD]
[TD]Course 2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Clark Kent[/TD]
[TD]2[/TD]
[TD]Course 1[/TD]
[TD]Course 3[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]
I need formulas that will insert the names of the courses each student has failed in the spaces in Columns C-G and total the amount failed in Column B pulling the data from Tab 1
Last edited: