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?


  • Monique Odom-Stearn
    Monique Odom-Stearn ✭✭✭✭✭✭

    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

  • JonEric Eubanks
    JonEric Eubanks ✭✭✭✭

    here is the screen shot I have used this formula but have run into an issue of repeating numbers .

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!