Currently have an excel sheet with 100+ names, a job course, start date of course, and end date of course.
I would like to filter to see who is currently doing a particular job course. Individuals are required to do at least 3 job courses so a basic filter does not work in this situation since it can't account for courses that have been completed (based on End Date)
<tbody>
</tbody>
I do have cells conditionally formatted green, if End Date is >TODAY(). But I think a filter indicating the name of the "Course" and "End Date" may be easier to apply.
Any advice is greatly appreciated.
Thanks!
I would like to filter to see who is currently doing a particular job course. Individuals are required to do at least 3 job courses so a basic filter does not work in this situation since it can't account for courses that have been completed (based on End Date)
Name | Course #1 | Stat Date | End Date | Course #2 | Start Date | End Date |
Bob | Logistics | 05-Mar-2017 | 10-Jun-2017 | Regulatory | 12-Jun-2017 | 31-Aug-2017 |
Joe | Regulatory | 10-Mar-2017 | 15-Aug-2017 | Logistics | 18-Jun-2017 | 15-Aug-2017 |
<tbody>
</tbody>
I do have cells conditionally formatted green, if End Date is >TODAY(). But I think a filter indicating the name of the "Course" and "End Date" may be easier to apply.
Any advice is greatly appreciated.
Thanks!