Students Schedule on Excel 2016

knaimi · Jan 12, 2018

My excel sheets has the schedule of all the students in my school. The schedule has the following fields. Please see the sample for one student below:
[TABLE="width: 919"]
<tbody>[TR]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD]P[/TD]
[/TR]
[TR]
[TD]1[/TD]
[TD]Counselor[/TD]
[TD]Grade[/TD]
[TD]Ident[/TD]
[TD]Student Name[/TD]
[TD]Period[/TD]
[TD]Course Title[/TD]
[TD]Teacher[/TD]
[TD]Room[/TD]
[TD][/TD]
[TD]Ident[/TD]
[TD]Student Name[/TD]
[TD]Period[/TD]
[TD]Course Title[/TD]
[TD]Teacher[/TD]
[TD]Room[/TD]
[/TR]
[TR]
[TD]2[/TD]
[TD]counselor 1[/TD]
[TD]10[/TD]
[TD]ID #[/TD]
[TD]Student 1[/TD]
[TD]1[/TD]
[TD]Class 1[/TD]
[TD]Teacher 1[/TD]
[TD]Room 1[/TD]
[TD][/TD]
[TD]ID #[/TD]
[TD]Student 6[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]3[/TD]
[TD]counselor 1[/TD]
[TD]10[/TD]
[TD]ID #[/TD]
[TD]Student 1[/TD]
[TD]2[/TD]
[TD]Class 2[/TD]
[TD]Teacher 2[/TD]
[TD]Room 2[/TD]
[TD][/TD]
[TD]ID #[/TD]
[TD]Student 890[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]4[/TD]
[TD]counselor 1[/TD]
[TD]10[/TD]
[TD]ID #[/TD]
[TD]Student 1[/TD]
[TD]3[/TD]
[TD]Class 3[/TD]
[TD]Teacher 3[/TD]
[TD]Room 3[/TD]
[TD][/TD]
[TD]ID #[/TD]
[TD]Student 908[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]5[/TD]
[TD]counselor 1[/TD]
[TD]10[/TD]
[TD]ID #[/TD]
[TD]Student 1[/TD]
[TD]4[/TD]
[TD]Class 4[/TD]
[TD]Teacher 4[/TD]
[TD]Room 4[/TD]
[TD][/TD]
[TD]ID #[/TD]
[TD]Student 1000[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]6[/TD]
[TD]counselor 1[/TD]
[TD]10[/TD]
[TD]ID #[/TD]
[TD]Student 1[/TD]
[TD]5[/TD]
[TD]Class 5[/TD]
[TD]Teacher 5[/TD]
[TD]Room 5[/TD]
[TD][/TD]
[TD]ID #[/TD]
[TD]Student 1001[/TD]
[TD]2[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]7[/TD]
[TD]counselor 1[/TD]
[TD]10[/TD]
[TD]ID #[/TD]
[TD]Student 1[/TD]
[TD]6[/TD]
[TD]Class 6[/TD]
[TD]Teacher 6[/TD]
[TD]Room 6[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]8[/TD]
[TD]counselor 1[/TD]
[TD]10[/TD]
[TD]ID #[/TD]
[TD]Student 1[/TD]
[TD]7[/TD]
[TD]Class 7[/TD]
[TD]Teacher 7[/TD]
[TD]Room 7[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

Each student has 7 lines that represent 7 different classes that he/she is currently enrolled in. In our school we have 1400 students * 7 lines which is equals to 9800 lines of information that is located between column A to I. In columns K to M, I need to add a list of individual students. I need to place a formula to find what class, teacher, and room the student will be in based on a period that I will add in column M. I just want to point out that each student has a unique ID number. The info in columns N, O, & P should change if I change the period # in column M. I hope you can help me find a formula to help with this task.
Thank you,

Scott T · Jan 12, 2018

I did not add all the data. Adjust ranges to match your data. Copy the formula in L2 across and down.

Excel 2010

A

B

C

D

E

F

G

H

I

J

K

L

M

N

1

Counselor

Grade

Ident

Student Name

Period

Course Title

Teacher

Room

Ident

Student Name

Period

Course Title

Teacher

Room

2

counselor 1

10

ID #

Student 1

1

Class 1

Teacher 1

Room 1

ID #

Student 6

2

Class 2six

6Teacher 2

Room 26

3

counselor 1

10

ID #

Student 1

2

Class 2

Teacher 2

Room 2

ID #

Student 890

7

Class 7890

Teacher 7

Room 78

4

counselor 1

10

ID #

Student 1

3

Class 3

Teacher 3

Room 3

ID #

Student 908

2

5

counselor 1

10

ID #

Student 1

4

Class 4

Teacher 4

Room 4

ID #

Student 1000

2

6

counselor 1

10

ID #

Student 1

5

Class 5

Teacher 5

Room 5

ID #

Student 1001

2

7

counselor 1

10

ID #

Student 1

6

Class 6

Teacher 6

Room 6

8

counselor 1

10

ID #

Student 1

7

Class 7

Teacher 7

Room 7

9

counselor 1

11

ID #

Student 6

1

Class 1six

6Teacher 1

Room 16

10

counselor 1

11

ID #

Student 6

2

Class 2six

6Teacher 2

Room 26

11

counselor 1

11

ID #

Student 6

3

Class 3six

6Teacher 3

Room 36

12

counselor 1

11

ID #

Student 6

4

Class 4sx

6Teacher 4

Room 46

13

counselor 1

11

ID #

Student 6

5

Class 5six

6Teacher 5

Room 56

14

counselor 1

11

ID #

Student 6

6

Class 6six

6Teacher 6

Room 66

15

counselor 1

11

ID #

Student 6

7

Class 7six

6Teacher 7

Room 76

16

counselor 2

11

ID #

Student 890

1

Class 1890

Teacher 11

Room 18

17

counselor 2

11

ID #

Student 890

2

Class 2890

Teacher 21

Room 28

18

counselor 2

11

ID #

Student 890

3

Class 3890

Teacher 31

Room 38

19

counselor 2

11

ID #

Student 890

4

Class 4890

Teacher 41

Room 48

20

counselor 2

11

ID #

Student 890

5

Class 5890

Teacher 51

Room 58

21

counselor 2

11

ID #

Student 890

6

Class 6890

Teacher 61

Room 68

22

counselor 2

11

ID #

Student 890

7

Class 7890

Teacher 7

Room 78

Sheet1

Cell Formulas
Range	Formula
L2	{=INDEX(F$2:F$22,MATCH($J2&$K2,$D$2:$D$22&$E$2:$E$22,0))}
L3	{=INDEX(F$2:F$22,MATCH($J3&$K3,$D$2:$D$22&$E$2:$E$22,0))}
M2	{=INDEX(G$2:G$22,MATCH($J2&$K2,$D$2:$D$22&$E$2:$E$22,0))}
M3	{=INDEX(G$2:G$22,MATCH($J3&$K3,$D$2:$D$22&$E$2:$E$22,0))}
N2	{=INDEX(H$2:H$22,MATCH($J2&$K2,$D$2:$D$22&$E$2:$E$22,0))}
N3	{=INDEX(H$2:H$22,MATCH($J3&$K3,$D$2:$D$22&$E$2:$E$22,0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

knaimi · Jan 12, 2018

Scott T said:
I did not add all the data. Adjust ranges to match your data. Copy the formula in L2 across and down.

Excel 2010

A B C D E F G H I J K L M N
Counselor Grade Ident Student Name Period Course Title Teacher Room Ident Student Name Period Course Title Teacher Room
counselor 1 ID # Student 1 Class 1 Teacher 1 Room 1 ID # Student 6 Class 2six 6Teacher 2 Room 26
counselor 1 ID # Student 1 Class 2 Teacher 2 Room 2 ID # Student 890 Class 7890 Teacher 7 Room 78
counselor 1 ID # Student 1 Class 3 Teacher 3 Room 3 ID # Student 908
counselor 1 ID # Student 1 Class 4 Teacher 4 Room 4 ID # Student 1000
counselor 1 ID # Student 1 Class 5 Teacher 5 Room 5 ID # Student 1001
counselor 1 ID # Student 1 Class 6 Teacher 6 Room 6
counselor 1 ID # Student 1 Class 7 Teacher 7 Room 7
counselor 1 ID # Student 6 Class 1six 6Teacher 1 Room 16
counselor 1 ID # Student 6 Class 2six 6Teacher 2 Room 26
counselor 1 ID # Student 6 Class 3six 6Teacher 3 Room 36
counselor 1 ID # Student 6 Class 4sx 6Teacher 4 Room 46
counselor 1 ID # Student 6 Class 5six 6Teacher 5 Room 56
counselor 1 ID # Student 6 Class 6six 6Teacher 6 Room 66
counselor 1 ID # Student 6 Class 7six 6Teacher 7 Room 76
counselor 2 ID # Student 890 Class 1890 Teacher 11 Room 18
counselor 2 ID # Student 890 Class 2890 Teacher 21 Room 28
counselor 2 ID # Student 890 Class 3890 Teacher 31 Room 38
counselor 2 ID # Student 890 Class 4890 Teacher 41 Room 48
counselor 2 ID # Student 890 Class 5890 Teacher 51 Room 58
counselor 2 ID # Student 890 Class 6890 Teacher 61 Room 68
counselor 2 ID # Student 890 Class 7890 Teacher 7 Room 78

<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]

[TD="align: right"]10[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"]2[/TD]

[TD="align: center"]3[/TD]

[TD="align: right"]10[/TD]

[TD="align: right"]2[/TD]

[TD="align: right"]7[/TD]

[TD="align: center"]4[/TD]

[TD="align: right"]10[/TD]

[TD="align: right"]3[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]5[/TD]

[TD="align: right"]10[/TD]

[TD="align: right"]4[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]6[/TD]

[TD="align: right"]10[/TD]

[TD="align: right"]5[/TD]

[TD="align: right"]2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]7[/TD]

[TD="align: right"]10[/TD]

[TD="align: right"]6[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]8[/TD]

[TD="align: right"]10[/TD]

[TD="align: right"]7[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]9[/TD]

[TD="align: right"]11[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]10[/TD]

[TD="align: right"]11[/TD]

[TD="align: right"]2[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]11[/TD]

[TD="align: right"]11[/TD]

[TD="align: right"]3[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]12[/TD]

[TD="align: right"]11[/TD]

[TD="align: right"]4[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]13[/TD]

[TD="align: right"]11[/TD]

[TD="align: right"]5[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]14[/TD]

[TD="align: right"]11[/TD]

[TD="align: right"]6[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]15[/TD]

[TD="align: right"]11[/TD]

[TD="align: right"]7[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]16[/TD]

[TD="align: right"]11[/TD]

[TD="align: right"]1[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]17[/TD]

[TD="align: right"]11[/TD]

[TD="align: right"]2[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]18[/TD]

[TD="align: right"]11[/TD]

[TD="align: right"]3[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]19[/TD]

[TD="align: right"]11[/TD]

[TD="align: right"]4[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]20[/TD]

[TD="align: right"]11[/TD]

[TD="align: right"]5[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]21[/TD]

[TD="align: right"]11[/TD]

[TD="align: right"]6[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

[TD="align: center"]22[/TD]

[TD="align: right"]11[/TD]

[TD="align: right"]7[/TD]

[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]

</tbody>
Sheet1

[TABLE="width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="width: 100%"]
<thead>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TH="width: 10px"]Cell[/TH]
[TH="align: left"]Formula[/TH]
[/TR]
</thead><tbody>[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L2[/TH]
[TD="align: left"]{=INDEX(F$2:F$22,MATCH($J2&$K2,$D$2:$D$22&$E$2:$E$22,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M2[/TH]
[TD="align: left"]{=INDEX(G$2:G$22,MATCH($J2&$K2,$D$2:$D$22&$E$2:$E$22,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N2[/TH]
[TD="align: left"]{=INDEX(H$2:H$22,MATCH($J2&$K2,$D$2:$D$22&$E$2:$E$22,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]L3[/TH]
[TD="align: left"]{=INDEX(F$2:F$22,MATCH($J3&$K3,$D$2:$D$22&$E$2:$E$22,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]M3[/TH]
[TD="align: left"]{=INDEX(G$2:G$22,MATCH($J3&$K3,$D$2:$D$22&$E$2:$E$22,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N3[/TH]
[TD="align: left"]{=INDEX(H$2:H$22,MATCH($J3&$K3,$D$2:$D$22&$E$2:$E$22,0))}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]

Hi Scott,

Is there a way to ignore the students' names in the formula and focus on the student id? What I found out is that the name of each student in the first list is in one cell that include lastname,first name last name; while the name of each student in the second list is in two cells where last name in one cell and the first name in another. The student ID in both list should match.

Thank you,

Scott T · Jan 12, 2018

Using Id#

Excel 2010

A

B

C

D

E

F

G

H

I

J

K

L

M

N

1

Counselor

Grade

Ident

Student Name

Period

Course Title

Teacher

Room

Ident

Student Name

Period

Course Title

Teacher

Room

2

counselor 1

10

1

Student 1

1

Class 1

Teacher 1

Room 1

6

Student 6

2

Class 2six

6Teacher 2

Room 26

3

counselor 1

10

1

Student 1

2

Class 2

Teacher 2

Room 2

890

Student 890

7

Class 7890

Teacher 7

Room 78

4

counselor 1

10

1

Student 1

3

Class 3

Teacher 3

Room 3

ID #

Student 908

2

5

counselor 1

10

1

Student 1

4

Class 4

Teacher 4

Room 4

ID #

Student 1000

2

6

counselor 1

10

1

Student 1

5

Class 5

Teacher 5

Room 5

ID #

Student 1001

2

7

counselor 1

10

1

Student 1

6

Class 6

Teacher 6

Room 6

8

counselor 1

10

1

Student 1

7

Class 7

Teacher 7

Room 7

9

counselor 1

11

6

Student 6

1

Class 1six

6Teacher 1

Room 16

10

counselor 1

11

6

Student 6

2

Class 2six

6Teacher 2

Room 26

11

counselor 1

11

6

Student 6

3

Class 3six

6Teacher 3

Room 36

12

counselor 1

11

6

Student 6

4

Class 4sx

6Teacher 4

Room 46

13

counselor 1

11

6

Student 6

5

Class 5six

6Teacher 5

Room 56

14

counselor 1

11

6

Student 6

6

Class 6six

6Teacher 6

Room 66

15

counselor 1

11

6

Student 6

7

Class 7six

6Teacher 7

Room 76

16

counselor 2

11

890

Student 890

1

Class 1890

Teacher 11

Room 18

17

counselor 2

11

890

Student 890

2

Class 2890

Teacher 21

Room 28

18

counselor 2

11

890

Student 890

3

Class 3890

Teacher 31

Room 38

19

counselor 2

11

890

Student 890

4

Class 4890

Teacher 41

Room 48

20

counselor 2

11

890

Student 890

5

Class 5890

Teacher 51

Room 58

21

counselor 2

11

890

Student 890

6

Class 6890

Teacher 61

Room 68

22

counselor 2

11

890

Student 890

7

Class 7890

Teacher 7

Room 78

Sheet1

Cell Formulas
Range	Formula
L2	{=INDEX(F$2:F$22,MATCH($I2&$K2,$C$2:$C$22&$E$2:$E$22,0))}
L3	{=INDEX(F$2:F$22,MATCH($I3&$K3,$C$2:$C$22&$E$2:$E$22,0))}
M2	{=INDEX(G$2:G$22,MATCH($I2&$K2,$C$2:$C$22&$E$2:$E$22,0))}
M3	{=INDEX(G$2:G$22,MATCH($I3&$K3,$C$2:$C$22&$E$2:$E$22,0))}
N2	{=INDEX(H$2:H$22,MATCH($I2&$K2,$C$2:$C$22&$E$2:$E$22,0))}
N3	{=INDEX(H$2:H$22,MATCH($I3&$K3,$C$2:$C$22&$E$2:$E$22,0))}
Press CTRL+SHIFT+ENTER to enter array formulas.

knaimi · Jan 12, 2018

Thanks, Scott. Unfortunately, when I entered the formula, I got the following error message "#N/A"

This is the formula I used in cell N2 "=INDEX(F$2:F$8891,MATCH($J2&$M2,$C$2:$C$8891&$E$2:$E$8891,0))"

F column is class, J is student ID, M is Period, C is student ID, E is period. I left column I blank.

any suggestions?

Scott T · Jan 12, 2018

Did you confirm the formula with CONTROL+SHIFT+ENTER? This is an array formula and you must use CSE. When you look in the formula bar you should she {} around the formula. The formula works for me. The N/A for the last two students is because I did not add them.

[TABLE="class: grid, width: 80%"]
<colgroup><col style="width: 25pxpx"><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TD][/TD]
[TD]A[/TD]
[TD]B[/TD]
[TD]C[/TD]
[TD]D[/TD]
[TD]E[/TD]
[TD]F[/TD]
[TD]G[/TD]
[TD]H[/TD]
[TD]I[/TD]
[TD]J[/TD]
[TD]K[/TD]
[TD]L[/TD]
[TD]M[/TD]
[TD]N[/TD]
[TD]O[/TD]
[TD]P[/TD]
[/TR]
[TR]
[TD="align: center"]1[/TD]
[TD]Counselor[/TD]
[TD]Grade[/TD]
[TD]Ident[/TD]
[TD]Student Name[/TD]
[TD]Period[/TD]
[TD]Course Title[/TD]
[TD]Teacher[/TD]
[TD]Room[/TD]
[TD="align: right"][/TD]
[TD]Ident[/TD]
[TD="align: right"][/TD]
[TD]Student Name[/TD]
[TD]Period[/TD]
[TD]Course Title[/TD]
[TD]Teacher[/TD]
[TD]Room[/TD]
[/TR]
[TR]
[TD="align: center"]2[/TD]
[TD]counselor 1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]1[/TD]
[TD]Student 1[/TD]
[TD="align: right"]1[/TD]
[TD]Class 1[/TD]
[TD]Teacher 1[/TD]
[TD]Room 1[/TD]
[TD="align: right"][/TD]
[TD="align: right"]6[/TD]
[TD="align: right"][/TD]
[TD]Student 6[/TD]
[TD="align: right"]2[/TD]
[TD]Class 26[/TD]
[TD]Teacher 26[/TD]
[TD]Room 26[/TD]
[/TR]
[TR]
[TD="align: center"]3[/TD]
[TD]counselor 1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]1[/TD]
[TD]Student 1[/TD]
[TD="align: right"]2[/TD]
[TD]Class 2[/TD]
[TD]Teacher 2[/TD]
[TD]Room 2[/TD]
[TD="align: right"][/TD]
[TD="align: right"]890[/TD]
[TD="align: right"][/TD]
[TD]Student 890[/TD]
[TD="align: right"]7[/TD]
[TD]Class 7890[/TD]
[TD]Teacher 7890[/TD]
[TD]Room 7890[/TD]
[/TR]
[TR]
[TD="align: center"]4[/TD]
[TD]counselor 1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]1[/TD]
[TD]Student 1[/TD]
[TD="align: right"]3[/TD]
[TD]Class 3[/TD]
[TD]Teacher 3[/TD]
[TD]Room 3[/TD]
[TD="align: right"][/TD]
[TD="align: right"]908[/TD]
[TD="align: right"][/TD]
[TD]Student 908[/TD]
[TD="align: right"]2[/TD]
[TD]Class 2890[/TD]
[TD]Teacher 2890[/TD]
[TD]Room 2890[/TD]
[/TR]
[TR]
[TD="align: center"]5[/TD]
[TD]counselor 1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]1[/TD]
[TD]Student 1[/TD]
[TD="align: right"]4[/TD]
[TD]Class 4[/TD]
[TD]Teacher 4[/TD]
[TD]Room 4[/TD]
[TD="align: right"][/TD]
[TD="align: right"]100[/TD]
[TD="align: right"][/TD]
[TD]Student 1000[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]#N/A[/TD]
[TD="align: right"]#N/A[/TD]
[TD="align: right"]#N/A[/TD]
[/TR]
[TR]
[TD="align: center"]6[/TD]
[TD]counselor 1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]1[/TD]
[TD]Student 1[/TD]
[TD="align: right"]5[/TD]
[TD]Class 5[/TD]
[TD]Teacher 5[/TD]
[TD]Room 5[/TD]
[TD="align: right"][/TD]
[TD="align: right"]1001[/TD]
[TD="align: right"][/TD]
[TD]Student 1001[/TD]
[TD="align: right"]2[/TD]
[TD="align: right"]#N/A[/TD]
[TD="align: right"]#N/A[/TD]
[TD="align: right"]#N/A[/TD]
[/TR]
[TR]
[TD="align: center"]7[/TD]
[TD]counselor 1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]1[/TD]
[TD]Student 1[/TD]
[TD="align: right"]6[/TD]
[TD]Class 6[/TD]
[TD]Teacher 6[/TD]
[TD]Room 6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]8[/TD]
[TD]counselor 1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]1[/TD]
[TD]Student 1[/TD]
[TD="align: right"]7[/TD]
[TD]Class 7[/TD]
[TD]Teacher 7[/TD]
[TD]Room 7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]9[/TD]
[TD]counselor 1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD]Student 2[/TD]
[TD="align: right"]1[/TD]
[TD]Class 1[/TD]
[TD]Teacher 1[/TD]
[TD]Room 1[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]10[/TD]
[TD]counselor 1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD]Student 2[/TD]
[TD="align: right"]2[/TD]
[TD]Class 2[/TD]
[TD]Teacher 2[/TD]
[TD]Room 2[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]11[/TD]
[TD]counselor 1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD]Student 2[/TD]
[TD="align: right"]3[/TD]
[TD]Class 3[/TD]
[TD]Teacher 3[/TD]
[TD]Room 3[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]12[/TD]
[TD]counselor 1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD]Student 2[/TD]
[TD="align: right"]4[/TD]
[TD]Class 4[/TD]
[TD]Teacher 4[/TD]
[TD]Room 4[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]13[/TD]
[TD]counselor 1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD]Student 2[/TD]
[TD="align: right"]5[/TD]
[TD]Class 5[/TD]
[TD]Teacher 5[/TD]
[TD]Room 5[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]14[/TD]
[TD]counselor 1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD]Student 2[/TD]
[TD="align: right"]6[/TD]
[TD]Class 6[/TD]
[TD]Teacher 6[/TD]
[TD]Room 6[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]15[/TD]
[TD]counselor 1[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]2[/TD]
[TD]Student 2[/TD]
[TD="align: right"]7[/TD]
[TD]Class 7[/TD]
[TD]Teacher 7[/TD]
[TD]Room 7[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]16[/TD]
[TD]counselor 2[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]6[/TD]
[TD]Student 6[/TD]
[TD="align: right"]1[/TD]
[TD]Class 16[/TD]
[TD]Teacher 16[/TD]
[TD]Room 16[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]17[/TD]
[TD]counselor 2[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]6[/TD]
[TD]Student 6[/TD]
[TD="align: right"]2[/TD]
[TD]Class 26[/TD]
[TD]Teacher 26[/TD]
[TD]Room 26[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]18[/TD]
[TD]counselor 2[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]6[/TD]
[TD]Student 6[/TD]
[TD="align: right"]3[/TD]
[TD]Class 36[/TD]
[TD]Teacher 36[/TD]
[TD]Room 36[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]19[/TD]
[TD]counselor 2[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]6[/TD]
[TD]Student 6[/TD]
[TD="align: right"]4[/TD]
[TD]Class 46[/TD]
[TD]Teacher 46[/TD]
[TD]Room 46[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]20[/TD]
[TD]counselor 2[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]6[/TD]
[TD]Student 6[/TD]
[TD="align: right"]5[/TD]
[TD]Class 56[/TD]
[TD]Teacher 56[/TD]
[TD]Room 56[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]21[/TD]
[TD]counselor 2[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]6[/TD]
[TD]Student 6[/TD]
[TD="align: right"]6[/TD]
[TD]Class 66[/TD]
[TD]Teacher 66[/TD]
[TD]Room 66[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]22[/TD]
[TD]counselor 2[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]6[/TD]
[TD]Student 6[/TD]
[TD="align: right"]7[/TD]
[TD]Class 76[/TD]
[TD]Teacher 76[/TD]
[TD]Room 76[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]23[/TD]
[TD]counselor 7[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]7[/TD]
[TD]Student 7[/TD]
[TD="align: right"]1[/TD]
[TD]Class 17[/TD]
[TD]Teacher 16[/TD]
[TD]Room 17[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]24[/TD]
[TD]counselor 7[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]7[/TD]
[TD]Student 7[/TD]
[TD="align: right"]2[/TD]
[TD]Class 27[/TD]
[TD]Teacher 26[/TD]
[TD]Room 27[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]25[/TD]
[TD]counselor 7[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]7[/TD]
[TD]Student 7[/TD]
[TD="align: right"]3[/TD]
[TD]Class 37[/TD]
[TD]Teacher 36[/TD]
[TD]Room 37[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]26[/TD]
[TD]counselor 7[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]7[/TD]
[TD]Student 7[/TD]
[TD="align: right"]4[/TD]
[TD]Class 47[/TD]
[TD]Teacher 46[/TD]
[TD]Room 47[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]27[/TD]
[TD]counselor 7[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]7[/TD]
[TD]Student 7[/TD]
[TD="align: right"]5[/TD]
[TD]Class 57[/TD]
[TD]Teacher 56[/TD]
[TD]Room 57[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]28[/TD]
[TD]counselor 7[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]7[/TD]
[TD]Student 7[/TD]
[TD="align: right"]6[/TD]
[TD]Class 67[/TD]
[TD]Teacher 66[/TD]
[TD]Room 67[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]29[/TD]
[TD]counselor 7[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]7[/TD]
[TD]Student 7[/TD]
[TD="align: right"]7[/TD]
[TD]Class 77[/TD]
[TD]Teacher 76[/TD]
[TD]Room 77[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]30[/TD]
[TD]counselor 7[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]890[/TD]
[TD]Student 890[/TD]
[TD="align: right"]1[/TD]
[TD]Class 1890[/TD]
[TD]Teacher 1890[/TD]
[TD]Room 1890[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]31[/TD]
[TD]counselor 7[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]890[/TD]
[TD]Student 890[/TD]
[TD="align: right"]2[/TD]
[TD]Class 2890[/TD]
[TD]Teacher 2890[/TD]
[TD]Room 2890[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]32[/TD]
[TD]counselor 7[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]890[/TD]
[TD]Student 890[/TD]
[TD="align: right"]3[/TD]
[TD]Class 3890[/TD]
[TD]Teacher 3890[/TD]
[TD]Room 3890[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]33[/TD]
[TD]counselor 7[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]890[/TD]
[TD]Student 890[/TD]
[TD="align: right"]4[/TD]
[TD]Class 4890[/TD]
[TD]Teacher 4890[/TD]
[TD]Room 4890[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]34[/TD]
[TD]counselor 7[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]890[/TD]
[TD]Student 890[/TD]
[TD="align: right"]5[/TD]
[TD]Class 5890[/TD]
[TD]Teacher 5890[/TD]
[TD]Room 5890[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]35[/TD]
[TD]counselor 7[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]890[/TD]
[TD]Student 890[/TD]
[TD="align: right"]6[/TD]
[TD]Class 6890[/TD]
[TD]Teacher 6890[/TD]
[TD]Room 6890[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]36[/TD]
[TD]counselor 7[/TD]
[TD="align: right"]11[/TD]
[TD="align: right"]890[/TD]
[TD]Student 890[/TD]
[TD="align: right"]7[/TD]
[TD]Class 7890[/TD]
[TD]Teacher 7890[/TD]
[TD]Room 7890[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]37[/TD]
[TD]counselor 3[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]908[/TD]
[TD]Student 908[/TD]
[TD="align: right"]1[/TD]
[TD]Class 1908[/TD]
[TD]Teacher 1890[/TD]
[TD]Room 1890[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]38[/TD]
[TD]counselor 3[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]908[/TD]
[TD]Student 908[/TD]
[TD="align: right"]2[/TD]
[TD]Class 2890[/TD]
[TD]Teacher 2890[/TD]
[TD]Room 2890[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]39[/TD]
[TD]counselor 3[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]908[/TD]
[TD]Student 908[/TD]
[TD="align: right"]3[/TD]
[TD]Class 3890[/TD]
[TD]Teacher 3890[/TD]
[TD]Room 3890[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]40[/TD]
[TD]counselor 3[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]908[/TD]
[TD]Student 908[/TD]
[TD="align: right"]4[/TD]
[TD]Class 4890[/TD]
[TD]Teacher 4890[/TD]
[TD]Room 4890[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]41[/TD]
[TD]counselor 3[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]908[/TD]
[TD]Student 908[/TD]
[TD="align: right"]5[/TD]
[TD]Class 5890[/TD]
[TD]Teacher 5890[/TD]
[TD]Room 5890[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]42[/TD]
[TD]counselor 3[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]908[/TD]
[TD]Student 908[/TD]
[TD="align: right"]6[/TD]
[TD]Class 6890[/TD]
[TD]Teacher 6890[/TD]
[TD]Room 6890[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD="align: center"]43[/TD]
[TD]counselor 3[/TD]
[TD="align: right"]10[/TD]
[TD="align: right"]908[/TD]
[TD]Student 908[/TD]
[TD="align: right"]7[/TD]
[TD]Class 7890[/TD]
[TD]Teacher 7890[/TD]
[TD]Room 7890[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]

Sheet1

[TABLE="class: grid, width: 85%"]
<tbody>[TR]
[TD]Array Formulas[TABLE="class: grid, width: 100%"]
<tbody>[TR="bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]
[TD="width: 10px"]Cell[/TD]
[TD="align: left"]Formula[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N2[/TH]
[TD="align: left"]{=INDEX(F$2:F$8891,MATCH($J2&$M2,$C$2:$C$8891&$E$2:$E$8891,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O2[/TH]
[TD="align: left"]{=INDEX(G$2:G$8891,MATCH($J2&$M2,$C$2:$C$8891&$E$2:$E$8891,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P2[/TH]
[TD="align: left"]{=INDEX(H$2:H$8891,MATCH($J2&$M2,$C$2:$C$8891&$E$2:$E$8891,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N3[/TH]
[TD="align: left"]{=INDEX(F$2:F$8891,MATCH($J3&$M3,$C$2:$C$8891&$E$2:$E$8891,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O3[/TH]
[TD="align: left"]{=INDEX(G$2:G$8891,MATCH($J3&$M3,$C$2:$C$8891&$E$2:$E$8891,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P3[/TH]
[TD="align: left"]{=INDEX(H$2:H$8891,MATCH($J3&$M3,$C$2:$C$8891&$E$2:$E$8891,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N4[/TH]
[TD="align: left"]{=INDEX(F$2:F$8891,MATCH($J4&$M4,$C$2:$C$8891&$E$2:$E$8891,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O4[/TH]
[TD="align: left"]{=INDEX(G$2:G$8891,MATCH($J4&$M4,$C$2:$C$8891&$E$2:$E$8891,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P4[/TH]
[TD="align: left"]{=INDEX(H$2:H$8891,MATCH($J4&$M4,$C$2:$C$8891&$E$2:$E$8891,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N5[/TH]
[TD="align: left"]{=INDEX(F$2:F$8891,MATCH($J5&$M5,$C$2:$C$8891&$E$2:$E$8891,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O5[/TH]
[TD="align: left"]{=INDEX(G$2:G$8891,MATCH($J5&$M5,$C$2:$C$8891&$E$2:$E$8891,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P5[/TH]
[TD="align: left"]{=INDEX(H$2:H$8891,MATCH($J5&$M5,$C$2:$C$8891&$E$2:$E$8891,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]N6[/TH]
[TD="align: left"]{=INDEX(F$2:F$8891,MATCH($J6&$M6,$C$2:$C$8891&$E$2:$E$8891,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]O6[/TH]
[TD="align: left"]{=INDEX(G$2:G$8891,MATCH($J6&$M6,$C$2:$C$8891&$E$2:$E$8891,0))}[/TD]
[/TR]
[TR]
[TH="width: 10px, bgcolor: [URL=https://www.mrexcel.com/forum/usertag.php?do=list&action=hash&hash=DAE7F5]#DAE7F5[/URL] "]P6[/TH]
[TD="align: left"]{=INDEX(H$2:H$8891,MATCH($J6&$M6,$C$2:$C$8891&$E$2:$E$8891,0))}[/TD]
[/TR]
</tbody>[/TABLE]
Entered with Ctrl+Shift+Enter. If entered correctly, Excel will surround with curly braces {}.
Note: Do not try and enter the {} manually yourself[/TD]
[/TR]
</tbody>[/TABLE]

knaimi · Jan 13, 2018

IT WORKED! I really want to thank you for your patience with me, Scott. I'm not an advance user, but your formula has saved me a lot of time.

I really appreciate your help,

Students Schedule on Excel 2016

knaimi

New Member

Excel Facts

Scott T

Well-known Member

knaimi

New Member

Scott T

Well-known Member

knaimi

New Member

Scott T

Well-known Member

knaimi

New Member

Similar threads

Forum statistics

Share this page

Students Schedule on Excel 2016

knaimi

New Member

Excel Facts

Scott T

Well-known Member

knaimi

New Member

Scott T

Well-known Member

knaimi

New Member

Scott T

Well-known Member

knaimi

New Member

Similar threads

Forum statistics

Share this page

We've detected that you are using an adblocker.

Which adblocker are you using?

Disable AdBlock

Disable AdBlock Plus

Disable uBlock Origin

Disable uBlock