I have a flight plan spreadsheet with filters on it but I need to run a filter which takes 2 criteria from 2 different columns (hence the auto filter is no help).
In column "C" I have "Work Location" and in column "K" I have # signs to denote those who travel Business Class and * signs for something else.
I need to filter the sheet to show the following:
1) All personnel working in the Training Department section in column "C"
2) All personnel who currently travel Business class (those who have a # sign in column "K")
The trouble I have, only being used to the auto filter, is that I can set the filter to select one or the other criteria but not both together as when the auto filter selects the "Training Department" personnel, those with # signs in column "K" get hidden as they are not part of this department.