I have a database of employee information such as Level (e.g., associate, manager, senior manager, executive), Skills (e.g., accounting, marketing), Skill Proficiency (e.g., low, medium, high). I have created custom lists for Level and Skill Proficiency where, for example, an executive is ranked higher than a manager.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com
fficeffice" /><o
></o>
<o> </o>
I want to create an advanced filter to filter by criteria such as:<o></o>
></o>
However, when I have tried this using the advanced filter, Excel will only sort alphabetically. So if I put Level is < manager, then the values that pass through are associate and executive – because “m” is larger than “a” and “e”.<o></o>
<o> </o>
Can anyone help?<o></o>
============
It is possible to put in multiple lines (i.e., OR lines) into your advanced filter criteria. However, I am filtering using about 10 criteria (Level, Skill, Proficiency, Country, State, City, etc), so using OR lines would make the filter too complicated. Ideally, I would want the advanced filter to sort using the custom list orders I have set up.
fficeffice" /><o></o><o
> </o>I want to create an advanced filter to filter by criteria such as:<o
></o>- Level is <= manager AND Skill Proficiency is > low
- <o>Where I would want employees who are associates or manager, and who have a Skill Proficiency of medium or high.</o>
- <o
></o>However, when I have tried this using the advanced filter, Excel will only sort alphabetically. So if I put Level is < manager, then the values that pass through are associate and executive – because “m” is larger than “a” and “e”.<o
></o><o
> </o>Can anyone help?<o
></o>============
It is possible to put in multiple lines (i.e., OR lines) into your advanced filter criteria. However, I am filtering using about 10 criteria (Level, Skill, Proficiency, Country, State, City, etc), so using OR lines would make the filter too complicated. Ideally, I would want the advanced filter to sort using the custom list orders I have set up.
