Filter Data Based on Multiple Criteria

[jerm8]

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)

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!

 

[NickRed18]

What exactly are you trying to filter? You said you would like to filter to see who is currently doing a particular job - does that mean highlight all names that are doing "Logistics", for example?

 

[jerm8]

correct. If possible, I would prefer to hide all cells that do not meet criteria, since the list is very large.