Blogroll

Get a website with Godaddy


Logo designer Fiverr Frelancer

Wednesday, April 27, 2011

MS Excel - Calculate rows after filter on

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

Amazon store

alidropship plugin

alidropship plugin
alidropship plugin

Total Pageviews

About