Rank like Subtotals
<p>It's possible use Rank like Subtotals, that only use de showing data?.</p>

<p>If I filter data by a column, I want than Rank function only use these datas</p>

<p>Example</p>

<pre><code>A   B   C   The column C its Rank of column B
a   5   3       
b   9   1  
a   2   4
c   7   2
</code></pre>

<p>Now if I apply a filter in column A for value 'a'</p>

<pre><code>A   B   C    I want the rank recalculate with this new data
a   5   1    --&gt; column C change from value 3 to value 1
a   2   2    --&gt; column C change from value 4 to value 2
</code></pre>

<p>Thanks</p>