Find top Ten numbers from a large list in a column
I want to identify the top ten users from a dual-column list, where the first column signifies the item and the second denotes the corresponding numerical value. The objective is to pinpoint the top performers, contingent upon the values in the second column. Additionally, I aspire to generate a graphical representation showcasing the foremost ten items along with their corresponding numerical values. Can some one help with this?
Answers
-
Hello @JonEric Eubanks, would you mind posting a screenshot of your columns so I can get a better idea of what you're looking for? Can you also explain how you're identifying the top performers? It is simply the highest number in the second column, or an additional calculation?
If my comment helped you, please help others by marking it as an accepted answer and consider helping me by clicking the 💡Insightful or ❤️Awesome buttons below!
Monique Odom-Stearn
Business Process Excellence Manager
Smartsheet Leader & Community Champion
Pronouns: She/Her (What’s this?)
“Take chances, make mistakes, get messy!” – Ms. Frizzle
-
here is the screen shot I have used this formula but have run into an issue of repeating numbers .
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!