Hello,
Every week I have to run the students' schedule report in Excel in our summer school and add the new students or find out any schedule changes to the master schedule in Excel. I compare between two schedules/tables line by line and see if there are any new students or schedule change and then I add them to the master schedule. As the number of students increase, this becomes a hectic job. Is there a way I can do that with a formula that may point out the new schedules without comparing lines?
Here is how the report for both tables looks like:
The most important information is: Student ID, Period, Course ID
Thank you for your help,
knaimi
Every week I have to run the students' schedule report in Excel in our summer school and add the new students or find out any schedule changes to the master schedule in Excel. I compare between two schedules/tables line by line and see if there are any new students or schedule change and then I add them to the master schedule. As the number of students increase, this becomes a hectic job. Is there a way I can do that with a formula that may point out the new schedules without comparing lines?
Here is how the report for both tables looks like:
| Counselor | Grade | Student ID | Last | First | Period | Course-ID | Course Title | Teacher | Room |
| Unassigned, _ | 9 | 123456 | Smith | John | 1 | 617070E | Intro to Art 1 | Staff A | F-10 |
| Unassigned, _ | 9 | 123456 | Smith | John | 2 | 614023E | Algebra Concepts/PreAlgebra | Staff B | F-11 |
| Unassigned, _ | 9 | 123456 | Smith | John | 3 | 613270E | Environmental Science | Staff C | F-12 |
| Unassigned, _ | 10 | 234567 | Finley | Erica | 1 | 611030E | Language Arts 3 | Staff A | F-13 |
| Unassigned, _ | 10 | 234567 | Finley | Erica | 2 | 628160E | Health | Staff B | F-14 |
| Unassigned, _ | 11 | 345678 | Kent | Clark | 2 | 613270E | Environmental Science | Staff C | F-12 |
The most important information is: Student ID, Period, Course ID
Thank you for your help,
knaimi
