title: how can use subtotal formula in MS-Excel for text category range
body: <p>I have a Table in Worksheet, that has a column with <code>Text</code> number category and contains integer values that start with 0. Same as "02".</p>
  
  <p>I want gaining the value which used for filtering Table in that column.</p>
  
  <p>According to I need one of each visible Cell Values in the column, used below formula:</p>
  
  <p><code>=SUBTOTAL(5,tblInsurance[DSK_LISTNO])</code></p>
  
  <p>But returned <code>0</code> as result! Ant not look at cell values.</p>
  
  <p>And I can't using <code>=SUBTOTAL(5,value(tblInsurance[DSK_LISTNO]))</code> for passing range values, to function as Integer.</p>
  
  <p>My Table hasn't Total row.</p>
  
  <p>So, How can I gaining the filtered value so take filtered Table by a column?</p>