title: Count number of rows/cells with data based on filters applied
body: <p>how to count the number of rows with data based on the filter applied?</p>
  
  <p>All I can find is methods like <code>xlUp, xlDown</code> which I cant apply to this as it will give me last row as opposed the number of rows with filtered data.</p>
  
  <p>example</p>
  
  <pre><code>1    animal age
  2    dog    10
  3    cat    15
  </code></pre>
  
  <p>I apply the filter on cat and get the following table:</p>
  
  <pre><code>1    animal age
  3    cat    15
  </code></pre>
  
  <p>with xlUp or down it will tell me last row number is 3, but obviously there is only 1 row with filtered data</p>