Results 1 to 4 of 4

Create a weekly course schedule

Threaded View

  1. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 365 version 2501
    Posts
    18,980

    Re: Create a weekly course schedule

    Hello Mikeuoft and Welcome to Excel Forum.
    Not exactly what you had mocked up, however perhaps close enough to qualify as "Any advice or suggestions".
    Some changes need to be made to the Course list page.
    1. Each record is assigned to a single day, i.e. no Wednesday Thursday in the same cell
    2. Separate start and end time
    3. [optional] Convert range to a table so the formula on the Schedule sheet will update automatically as rows are added/deleted.
    The formula for the Schedule sheet is:
    Formula: copy to clipboard
    =IFERROR(IFERROR(INDEX('course list'!$C$2:$C$9&'course list'!$D$2:$D$9&CHAR(10)&'course list'!$F$2:$F$9&CHAR(10)&'course list'!$J$2:$J$9&" "&'course list'!$K$2:$K$9,AGGREGATE(15,6,(ROW('course list'!$D$2:$D$9)-ROW('course list'!$D$1))/('course list'!$G$2:$G$9=B$1)/('course list'!$H$2:$H$9=$A2),COUNTIFS($B$1:B$1,B$1))),INDEX('course list'!$B$2:$B$9,AGGREGATE(15,6,(ROW('course list'!$D$2:$D$9)-ROW('course list'!$D$1))/('course list'!$G$2:$G$9=B$1)/('course list'!$I$2:$I$9=$A2),COUNTIFS($B$1:B$1,B$1)))),"")

    Conditional formatting is applied using:
    For graduate courses: =ISNUMBER(SEARCH("Grad",B2))
    I could not think of a way to turn the whole block green, perhaps someone else can help there.
    For other courses: =OR(B2<>"",ISEVEN(SUMPRODUCT(--(B$1:B1<>""))))
    Note that after new courses are added on the course list sheet you may need to use AutoFit Row Height (under Format on the Home tab)
    Let us know if you have any questions.
    Attached Files Attached Files
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Auto Create Daily Break Schedule from Weekly Work schedule
    By colema62 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-27-2021, 04:31 PM
  2. [SOLVED] I need help with weekly NFL schedule
    By TS49 in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 11-21-2019, 07:33 PM
  3. [SOLVED] Weekly schedule data to daily schedule
    By Sarah_L in forum Excel General
    Replies: 6
    Last Post: 09-16-2019, 04:36 AM
  4. Weekly Schedule
    By tiggermita in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-24-2013, 08:20 PM
  5. Replies: 0
    Last Post: 06-19-2012, 11:36 AM
  6. Weekly Schedule, help create form
    By StevenPar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 06-26-2005, 01:23 AM
  7. Weekly schedule?
    By shikamikamoomoo in forum Excel General
    Replies: 0
    Last Post: 04-13-2005, 07:44 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1