Course Schedule Formulas

[KaylaP]

Hi,

Can formulas fill the time slots for the courses with Course Codes? I manually entered a few examples.

Thanks

[KaylaP]

Hi,

I am patient for help but I thought I would provide another layout option which might make more sense.

Please see attached.

Thank you,
KaylaP

[Bo_Ry]

Please try at R6

=TEXTJOIN(",",,FILTER($B$6:$B$21,(($K$6:$K$21<=$Q6)*(N(+$L$6:$L$21)>$Q6)+($M$6:$M$21<=$Q6)*(N(+$N$6:$N$21)>$Q6))*(D$6:D$21="x"),""))

[KaylaP]

Thank you @Bo_Ry this a perfect solution!



After some trials there seems to be a glitch. See next reply thanks.

[KaylaP]

After some trials with different time slots and time intervals I see an issue. There is no start time at 5:45 am yet it shows on the schedule.

Can you take a look please.

[Bo_Ry]

Don't use drag or auto-fill with time

select M10 and key in 05:30

[KaylaP]

Thank you so much. I did not know that each has to be keyed in.

Have a great day!