HI
Hope someone can help me.
I have a course schedule with names of trainers in column A and dates for a calendar year in row 2
I have validation lists that contain courses assigned to that week and we assign trainers to the courses they are to deliver.
This is a screen shot of a small sample version of that tab
![1728497462668.png 1728497462668.png](https://chandoo.org/forum/data/attachments/88/88804-884418c9dbb0be8d6c52de3a9847ffc6.jpg)
on a separate tab, I have a monthly summary where I select name and month and it populates the activity on that day using a filter formula that looks for day and name in the schedule tab.
What I am unable to do is, below each course for each day, is populate the names of the other trainers they will be working with on that day? This screen shot is how I want it to look but i just cannot collate those names. In addition, I want to exclude activites such as Annual Leave, Absent, etc in whatever formula I use for this.
![1728499415415.png 1728499415415.png](https://chandoo.org/forum/data/attachments/88/88808-bdd5932fa9a64225482dd26e5f6bd9ec.jpg)
Hope someone out there can help with this.
Thanks in advance
Hope someone can help me.
I have a course schedule with names of trainers in column A and dates for a calendar year in row 2
I have validation lists that contain courses assigned to that week and we assign trainers to the courses they are to deliver.
This is a screen shot of a small sample version of that tab
![1728497462668.png 1728497462668.png](https://chandoo.org/forum/data/attachments/88/88804-884418c9dbb0be8d6c52de3a9847ffc6.jpg)
on a separate tab, I have a monthly summary where I select name and month and it populates the activity on that day using a filter formula that looks for day and name in the schedule tab.
What I am unable to do is, below each course for each day, is populate the names of the other trainers they will be working with on that day? This screen shot is how I want it to look but i just cannot collate those names. In addition, I want to exclude activites such as Annual Leave, Absent, etc in whatever formula I use for this.
![1728499415415.png 1728499415415.png](https://chandoo.org/forum/data/attachments/88/88808-bdd5932fa9a64225482dd26e5f6bd9ec.jpg)
Hope someone out there can help with this.
Thanks in advance
Last edited: