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
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