Here is my prediciment…. I’ll create an example
Column A Column B Column C
Job Primary Alternate
Sweep Joe Katie
Trash Katie John
Mop Erica Joe
Bathroom Steve Erica
Ultimately I would like to be able to Filter on a name i.e. Katie and determine what jobs Katie has, whether she is a “Primary” or an “Alternate”
With Filtering just column B I lose the information from Column C meaning I wouldn’t be able to find out what Katie is an “Alternate” for.
In a perfect world on a septerate sheet I would have a list of all the names and be able to select one and below it would show all the jobs (Column A) the person has.
I’d appreciate any help!