RankIf options (rank based on another value)

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



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!