| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Indirect filter
I want to filter a data table usiong a criteria stored in a cell. I tried
indirect and some macros with no result in Excel 2007. Thanks in advance for any light about this problem. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Indirect filter
You need to have at least two rows in the filter criterial... one having the
column heading and the other the condition... Once you have that then you can use Advanced Filter on the Data tab... "Luis Guembes" wrote: I want to filter a data table usiong a criteria stored in a cell. I tried indirect and some macros with no result in Excel 2007. Thanks in advance for any light about this problem. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Allow EXCEL INDIRECT(ADDRESS()) and INDIRECT(RANGE()) functions | Excel Worksheet Functions | |||
| Filter PivotTable dropdown items to match report filter | Excel Discussion (Misc queries) | |||
| INDEX("a"&COLUMNS(INDIRECT(A1):INDIRECT(A2)):A30,4) | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
| "Criteria Range" in the "Data/Filter/Advanced Filter" to select Du | Excel Worksheet Functions | |||
Hybrid Mode
