count visible cells after autofilter

L

Ludo

Hi,

I have a worksheet where i use Autofilter to select one item from the
list.
What i would like to obtain is that, when i select an item with the
Autofilter that i can place the number of visible rows containing data
in cell F1, so not counting the empty rows.

After selecting an other item from the Autofilter list, i would like
that the cell F1 returs the number of visible cells at that moment.

Is it possible to do this?
Any help welcome.

Regards,
Ludo
 
S

Stefi

If you mean the number of visible rows
=SUBTOTAL(102,A:A)

Regards,
Stefi

„Ludo†ezt írta:
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autofilter problem 7
Select rows with visible data 0
SELECTING AN ITEM FROM AUTO FILTER ! 2
How to get the count of filtered rows after applying autofilter? 2
after autofilter/delete rows left not visible 1
Autofilter Range 6
autofill to visible cells only 5
array-to-row autofilter issue 3

Top