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?

--
Biff
Microsoft Excel MVP


"Reagan" wrote in message
...
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