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.