Ranking Prices by Name - Need Formula Help

J.C. Benny

Hi,

So I can't seem to figure this out. Below I have the name of a manufacturer with how much we are spending with them in no particular order. I'd like to use a formula that tells me, in decending order, the top 10 manufacturers we've spent the most money on.

I would need the information to be listed like below

STERIS Corporation $1,334,590

Stryker Corporation $757,564

Stryker Endoscopy $361,635

And so on showing the top 10…

I can't mess with the columns below becuase those are referencing a different sheet so I need to create a chart next to the table that displays the ranking.

It's unlikely I'd have duplicate prices but I'd like to avoid that problem if possible too.

I've tried versions of Rankeq with and without collect but I can't seem to get anything going.

I'd very much appreciate any help on this!

EvanShortreed

Good Afternoon,

Have you tired making a report looking at this sheet? Once you do you can do the following:

1. Group by Manufacturer
2. Sum the values

Let me know if this helps or if you need further assistance on a call.

J.C. Benny

https://community.smartsheet.com/discussion/comment/445331#Comment_445331

I don't believe that'll work only because I need to reference and manipulate the data in a dashboard (not as a report). :(

EvanShortreed

Hi J.C,

I am happy to hop on a call to show you what I have in mind with the report that we can make a chart on a dashboard.