I have report with information on class components for university courses that I would like to produce a grid style schedule for (please refer to screenshot for the end product)NUR1100 GRID SCHEDULE.
The data I would like to populate this from Looks similar to this:
| Course | ClassID | ClassSection | StartDate | StartTime | EndDate | EndTime |
| ——– | ——– |——– | ——– |——– | ——– |——– |
| NUR1100 | 15161 | LB01 | 17-Feb-25 | 07:30 | 24-Mar-25 | 10:30 |
| NUR1100 | 15162 | LB02 | 17-Feb-25 | 10:30 | 24-Mar-25 | 13:30 |
| NUR1100 | 15163 | TU01 | 17-Feb-25 | 13:30 | 24-Mar-25 | 14:30 |
| NUR1100 | 15164 | LB03 | 17-Feb-25 | 14:30 | 24-Mar-25 | 17:30 |
| NUR1100 | 15165 | RS01| 25-Mar-25 | 07:30 | 27-Mar-25 | 15:30 |
Some Class Sections are recurring i.e. LB01 is every Monday for 6 weeks. Others are held over 3 specific days (RS01 is Tuesday 25 Mar 25, Wednesday 26 Mar 25 and Thursday 27 March from 07:30 to 15:30).
Could anybody provide me assistance to do this in either MS Excel or PowerBI? I have no starting code in VBA as yet – I have so far trialled the below fomula with limited success:
=TEXTJOIN(” – “,TRUE,CHOOSECOLS(FILTER(Report!$A:$AT,(Report!$E:$E=”NUR1100”)((Grid!$C8>=Report!$AR:$AR)(Grid!$C8<=Report!$AS:$AS))(Grid!E$2>=Report!$AP:$AP)(Grid!E$2<=Report!$AQ:$AQ),0),5,7,2))
Grid populated with Course – Course Section and ClassID for times and dates but still shows everyday rather than 1 per week for LB01, LB02, LB03 and TU04
Fabian Rogers is a new contributor to this site. Take care in asking for clarification, commenting, and answering.
Check out our Code of Conduct.