how can I rank within a filtered list in Excel?
 

I'd like to have a dynamic report that ranks my lists based on an
autofiltered list. In other words, I'd like to toggle the criteria that
qualifies the lists content, and have excel generate "ranks" based on the
values returned. Currently the rankings are based on the overall list,
includeing the records that are filtered out.

Assuming that Column B contains the values to be ranked, and the first
row contains your headers/labels...

C2, copied down:

=SUMPRODUCT(SUBTOTAL(3,OFFSET($B$2:$B$10,ROW($B$2: $B$10)-MIN(ROW($B$2:$B$
10)),0,1)),--(B2<$B$2:$B$10))+1

Hope this helps!

In article ,
"Brandon" wrote:

I'd like to have a dynamic report that ranks my lists based on an
autofiltered list. In other words, I'd like to toggle the criteria that
qualifies the lists content, and have excel generate "ranks" based on the
values returned. Currently the rankings are based on the overall list,
includeing the records that are filtered out.