Create individuals' Timetables from Schedule of Global Data

Yes! That's great. I could never have worked that out. The only problem in making it work on my real spreadsheet is that I have 10 separate tables from which I need to populate the cells on the individual timesheet: I have DataTable1, DataTable2 ... DataTable10. How do I rewrite your formula to accommodate all my data tables then? Thanks!

OK, I have added another data table to the file. Thanks ever so much for the help.Schedule Example, Jacc.xlsx

OK, I will put all the data into one table. Thanks!

Hello, I put all the data into one table, but I can't get the individual timetable generation to work properly. It only picks up some of the courses for each teacher, not all of them. I can't work out why it is doing this ... Thanks!

I solved the last post: I don't know why but some of the numbers in my period column weren't being read as numbers—retyping the numbers solved it.

I do have another issue: I have a few classes that are year long and that means that instead of 1 or 2 in the semester column I write "1 & 2." I need the formula to pick up on this. Can it be done? Thanks!

Hello, I have a few classes that are year long and that means that instead of 1 or 2 in the semester column I write "1 & 2." I need the formula on the timetable sheet to pick up on this. Can it be done? You can see what I mean on the attached sheet where I have written the classes on the timetable sheet manually; I need the formuka to do the same on the last sheet. Thanks very much! Schedule Example, Jacc.xlsx

Does anyone know how to get the formula to pick up on semester long, one day a week scheduled classes? The excel file is attached to the previous post. Thanks!

Hello, I need to amend an array formula so that it will populate the cells in a teacher's individual timetable. At the moment the formula works by putting a teacher's classes into either the first or second semester on a timetable sheet by reading "1" or "2" in the semester column from the relevant table. I have one course that is year long, however, so the semester column shows "1 & 2." How to I change the array formula so that this year long course appears in the timetable? At the moment the "1 & 2" values are ignored. You can see what I mean on the attached sheet where I have written the classes on the timetable sheet manually; I need the formuka to do the same on the last sheet. Thanks very much! Attachment 385559

Hello, I want to add another part to the formula below so that it adds ISBN numbers to my sheet. But I can't get it to work. Here's the formula as it stands now:

Please Login or Register  to view this content.

I need to add &CHAR(10) to generate a new line, then the text "ISBN: " (with a space) and then select the ISBN value from my DataTable. Any ideas? Thanks!

Hello Jacc. Thanks for the advice and all the help before. By the way, I managed to add the ISBNs in the end, but I'm working on timetable stuff again. It's that time of year for me.

Hello Jacc. Could you tell me what these "ииии" characters do in your original formula? Thanks!

Thank you Jacc. The link was helpful too.