Rank items in a filter

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
 
T

T. Valko

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top