RankIf options (rank based on another value)

puddlian

Hi all

I have a sheet that lists usage metrics on specific items. Items are categorized by group in another cell. There are 82 different groups and I am trying to find a way to rank these items based on the usage metrics PER GROUP

I need to create a RankIf formula and need you expert knowledge to help do this without creating 82 different sheets of data

Thanks!

Genevieve P.

Hi @puddlian

You an use the COLLECT function within RANKEQ to Rank Per Group, like so:

=RANKEQ([Metric Column]@row, COLLECT([Metric Column]:[Metric Column], Group:Group, Group@row))

Let me know if this is what you were looking to do!

Cheers,

Genevieve