Need a formula(s) to create a table

[naaim]

Here is the excel sheet where I am trying to create a formula.
New TABLE.xlsx

I have created both tables manually without using any formula. Now I need a formula to create the TEACHERS INDIVIDUAL TIME TABLE by using the datas iN STUDENT AFTERNOON TIMETABLE.

If you have any question feel free to reply to this thread
Moderator's note - email removed, it is not good practice to include perspnal details in a public forum

[bebo021999]

This look like a real interesting chalenge.

Could you please give more info in

*The logic that helps you to create the TEACHER table?

* What are the coloured cells? subjects' titles?

* Who (teacher) is assigned to what (subject title)?

[naaim]

THESE ARE THE NAMES OF THE TEACHERS AND I HAVE GIVEN A COLOR TO EACH TEACH
Attachment 370718

Let me explain how the STUDENT AFTERNOON TIMETABLE is made first.
Column A represents grades from 1 -5
Column B = names of the class teacher. (This wont be needed to make the TEACHERS INDIVIDUAL TIMETABLE)
Column C = dont need to know
and the rest are the classes

NO TEACHER IS ASSIGNED TO A SPECIAL SUBJECT.

AND THE LOGIC BEHIND THE TEACHER TIMETABLE IS:
This time tables makes it easier for the Teachers to see which GRADEs they have to attend. Its the same table made in two persons point of few. (Students and Teachers)

For an example:
I (Naaim) have got purple. I teach IS for grade 2-5, HPE for grade 1-2 and CA for 1-2.

NOW LETS HAVE A LOOK AT THE TEACHERS INDIVIDUAL TIMETABE.
My column is 27 as you can see in the attachment. SUNDAY I have got IS for Grade 3, 2 and 4. You can see that in Student table. Now if you look at the TEACHERS TABLE, in my column (27) you can see 3, 2 and 4.

PS: THE INFORMATION IN THE TEACHERS INDIVIDUAL TABLE (which I created manually) may not be acurate.

If you still have any question please reply to this thread. Thanks.

[bebo021999]

Is the attachment in #1 the latest? I could not open the attachment in #3.

I can see on SUNDAY , Naam teachs IS for grade 5,1,2 (column F,J,K). Is it correct or i miss something?

Also, can you add a table with teachers down,grade and classes accross?

for example:

Name__________classes____________grade 1________grade2________grade3_________grade4__________grade5
Naam____________IS________________0_____________2_____________3______________4______________5
Naam___________HPE________________1_____________2_____________0______________0______________0
Naam .......................

Azma
...
...

[mngrshoaib]

Color references cAN BE used as criteria to search the relevant cells of relevant teacher

[naaim]

Attachment in #3 was a screenshot. so here it is again:
capture-20150116-183818.png

As you can see in the screenshot or in the excel sheet, I have given a different color to each teacher. (AZ & BA)

AND YES THE DATAS IN TEACHER TABLE WERENT CORRECT. SO I HAVE EDITED THE THREAD (CHANGED THE ATTACHMENT) AND NOW THE DATAS OF THE FIRST 3 TEACHERS ARE DEFINATELY CORRECT IN THE ATTACHMENT.