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.
|