Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter Multiple Criteria
Hello
I have an employee listing with individual task qualifications for each employee. There are 20 tasks at this time. I would like to be able to provide a list of employees that are qualified for sets of tasks. So this may be any combination of 1 -20 tasks. Column D contains the qualifications and would have, for instance, Task1 Task2, Task4, Task6, etc, So I would like to have a list of employees that are qualified on task1,task4,task6 and task10, Custom auto filter only allows 2 critreon. What would be the best way to accomplish this? Thanks! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto Filter Multiple Criteria
On Wednesday, April 4, 2012 9:23:17 AM UTC-5, Steve wrote:
Hello I have an employee listing with individual task qualifications for each employee. There are 20 tasks at this time. I would like to be able to provide a list of employees that are qualified for sets of tasks. So this may be any combination of 1 -20 tasks. Column D contains the qualifications and would have, for instance, Task1 Task2, Task4, Task6, etc, So I would like to have a list of employees that are qualified on task1,task4,task6 and task10, Custom auto filter only allows 2 critreon. What would be the best way to accomplish this? Thanks! You can use datafilterADVANCED filter. If all else fails send your file direct to dguillett1 @gmail.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
search criteria - auto filter | Excel Programming | |||
Auto Filter - capture criteria used | Excel Discussion (Misc queries) | |||
Is it possible to use auto filter to select more than 2 criteria? | Excel Discussion (Misc queries) | |||
Auto Filter by Criteria | Excel Worksheet Functions | |||
Help with passing date value into Auto filter criteria | Excel Programming |