| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto filter question
have a look in HELP index for SUBTOTAL
-- Don Guillett SalesAid Software "scott23" wrote in message om... Hi folks ... In my table i am using autofilter on the headings. In another worksheet i have many different formulas doing data analysis on this table using ranges of data from it. My question is, how can i filter different columns of data in this table and then have the formulas use only the filtered range of data that is visible rather than the total range of data regardless of the filter. Thanks in advance. scott |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Auto filter question | Excel Worksheet Functions | |||
| Auto Filter question | Excel Discussion (Misc queries) | |||
| Auto Filter question | Excel Worksheet Functions | |||
| Auto filter question??? | Excel Discussion (Misc queries) | |||
| auto filter question | Excel Worksheet Functions | |||
![Don Guillett[_4_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
