Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto filter question
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 |
#2
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
auto filter question
Hi Scott,
Look at SUBTOTAL Worksheet Function in Excel HELP SUBTOTAL(9,range) gets you equivalent of normal =SUM(range) you may have up to 29 ranges in SUBTOTAL SUBTOTAL(9,range1, range2, ..., range29) you may have up to 30 arguments in SUM Hope the worksheet function is what you are looking for as opposed to needing a macro. ---- David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "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 |