Filter Data Based on Multiple Criteria

jerm8

New Member
Joined
Jul 11, 2017
Messages
2
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)

NameCourse #1Stat DateEnd DateCourse #2Start DateEnd Date
BobLogistics05-Mar-201710-Jun-2017Regulatory12-Jun-201731-Aug-2017
JoeRegulatory10-Mar-201715-Aug-2017Logistics18-Jun-201715-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

Board Regular
Joined
May 25, 2017
Messages
76
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

New Member
Joined
Jul 11, 2017
Messages
2
correct. If possible, I would prefer to hide all cells that do not meet criteria, since the list is very large.
 

Forum statistics

Threads
1,077,617
Messages
5,335,260
Members
399,009
Latest member
twcaddell

Some videos you may like

This Week's Hot Topics

Top