---------Index----------------------Animal-------------------
---------1-----------------------Cat-------------------
---------2-----------------------Dog------------------
---------3-----------------------Dog-----------------
---------4-----------------------cat------------------
above table has shown 4 rows / records...what if i set filter on column Animal and filter for dog
below cell should able to show the number of records after applying filter for dog
---- Total record--------------------------4--------------------"filter on dog"
-----Total after filter on Dog------------2---------------------------------------
answer is following...
=subtotal(3,b1:b100)
No comments:
Post a Comment