Rank items in a filter

  • Thread starter Thread starter Reagan
  • Start date Start date
R

Reagan

Hello

Is there a way to rank items only if they are chosen in filter? For
instance, if I filtered on Type X in the series below, I would like a type
rank for just X items. Normally I would just sort and rank manually but this
is set up is across multiple tabs.

Thank you!

Clmn A ClmnB ClmnC
Type Sales Type Rank
X $50 1
Y $25 3
Y $30 2
X $3 2
Y $100 1
 
if I filtered on Type X

If you filter on Type X then this is what is displayed:

Type Sales Type Rank
X $50 1
X $3 2

So, isn't it already ranked?
 
Back
Top