| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
counting filtered rows
I have a column of data that I filter according to user
input. I need to count the number of items in the filter. For example, I filter column A for "XYZ" and discover that there are 11 items in the filter. I can count them visually but I need to count them programmatically. How can I do that? If I try to run Countif(), I get an error message. Gmet |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
counting filtered rows
Hi
see: http://www.contextures.com/xlautofilter03.html#Count -- Regards Frank Kabel Frankfurt, Germany gmet wrote: I have a column of data that I filter according to user input. I need to count the number of items in the filter. For example, I filter column A for "XYZ" and discover that there are 11 items in the filter. I can count them visually but I need to count them programmatically. How can I do that? If I try to run Countif(), I get an error message. Gmet |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
counting filtered rows
Have a look in HELP index for SUBTOTAL
-- Don Guillett SalesAid Software "gmet" wrote in message ... I have a column of data that I filter according to user input. I need to count the number of items in the filter. For example, I filter column A for "XYZ" and discover that there are 11 items in the filter. I can count them visually but I need to count them programmatically. How can I do that? If I try to run Countif(), I get an error message. Gmet |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filtered Counting | Excel Discussion (Misc queries) | |||
| Help Please-Counting Filtered Rows | Excel Worksheet Functions | |||
| Counting a Filtered List | Excel Discussion (Misc queries) | |||
| Counting within a filtered range | Excel Worksheet Functions | |||
| Filtered Visible Rows & VBA Non-Filtered Rows Displayed | Excel Programming | |||
Linear Mode
