Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count rows after filter
I want to count how many rows are left in the worksheet after I used filter
and some rows had been hidden. COUNTA give me all rows and not the one after filter. Are there any function can do that or need to use VBA? Thank you. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count rows after filter
hi, anonymous !
I want to count how many rows are left in the worksheet after I used filter and some rows had been hidden. COUNTA give me all rows and not the one after filter. Are there any function can do that or need to use VBA? subtotal(... worksheet-function only tracks visible cells/rows after any autofilter criteria so... counting numbers: =subtotal(2,<filtered range) counting text/any: =subtotal(3,<filtered range) hth, hector. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count rows after filter
Hello,
Thank you. It work out good. I know subtotal can sum but forget/not realize it can do counting etc too. Thanks a lot. Learn-more "Héctor Miguel" wrote: hi, anonymous ! I want to count how many rows are left in the worksheet after I used filter and some rows had been hidden. COUNTA give me all rows and not the one after filter. Are there any function can do that or need to use VBA? subtotal(... worksheet-function only tracks visible cells/rows after any autofilter criteria so... counting numbers: =subtotal(2,<filtered range) counting text/any: =subtotal(3,<filtered range) hth, hector. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced Filter - filter rows < | Excel Discussion (Misc queries) | |||
Count rows and insert number to count them. | Excel Discussion (Misc queries) | |||
count with filter | Excel Worksheet Functions | |||
Count Filter | Excel Discussion (Misc queries) | |||
filter and count | Excel Discussion (Misc queries) |