Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter
Hi
I have a drop down list in colum "A" of my Excel sheet that has 7 values. I want to filter my results to show only those rows that satisfy 4 values in the list. I am using Excel 2000. Please advise, if this can be done using any Excel function or If this can be done writing any vba code. Thanks |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter
You can use a helper column to set up your multiple criteria, like
this: =IF(OR(A2="a",A2="b",A2="c",A2="d"),1,0) and copy this down. Then you could apply your autofilter to this column, and choose 1 from the filter drop-down - this will enable you to filter the rows where column contains a or b or c or d, but you can amend to suit your data. Hope this helps. Pete On Dec 5, 1:46*pm, ub wrote: Hi I have a drop down list in colum "A" of my Excel sheet that has 7 values. I want to filter my results to show only those rows that satisfy 4 values in the list. I am using Excel 2000. Please advise, if this can be done using any Excel function or If this can be done writing any vba code. Thanks |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Filter
Hi,
That is one of the things that the Advanced Filter command allows you to do. Enter the four items in a range, lets say D2:D5, in D1 enter the title of column A exactly as it is displayed in your original data. Choose Data, Filter, Advanced Filter In the List range specify your column A range In the Criteria range specify D1:D5 Click OK If you upgrade to 2007 you will find that when you open the AutoFilter each item is listed with a check box and you can quickly and easily pick any combination of items. -- If this helps, please click the Yes button Cheers, Shane Devenshire "ub" wrote: Hi I have a drop down list in colum "A" of my Excel sheet that has 7 values. I want to filter my results to show only those rows that satisfy 4 values in the list. I am using Excel 2000. Please advise, if this can be done using any Excel function or If this can be done writing any vba code. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
Copy only visible cells after filter is applied/ sum after filter | Excel Worksheet Functions | |||
filter: how to print filter list options in dropdown box | Excel Discussion (Misc queries) | |||
"Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions |