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

Top