Formulas and Functions

Formulas and Functions

Ask for help with your formula and find examples of how others use formulas and functions to solve a similar problem.

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

  • Community Champion

    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

    Architecture Solutions 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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!

Trending in Formulas and Functions