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?
Monique Odom
Business Process Excellence Manager
Smartsheet Automagician & Leader
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
Check out the Formula Handbook template!