Ranking Prices by Name - Need Formula Help
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!
Answers
-
Good Afternoon,
Have you tired making a report looking at this sheet? Once you do you can do the following:
- Group by Manufacturer
- Sum the values
Let me know if this helps or if you need further assistance on a call.
-
I don't believe that'll work only because I need to reference and manipulate the data in a dashboard (not as a report). :(
-
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.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.6K Get Help
- 433 Global Discussions
- 136 Industry Talk
- 466 Announcements
- 4.9K Ideas & Feature Requests
- 143 Brandfolder
- 147 Just for fun
- 63 Community Job Board
- 466 Show & Tell
- 32 Member Spotlight
- 2 SmartStories
- 298 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!