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
ffice
ffice" /><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.




<o


I want to create an advanced filter to filter by criteria such as:<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


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


Can anyone help?<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.