Use Max function to return person's name?

Maz Uddin
Maz Uddin ✭✭✭✭
edited 04/13/22 in Formulas and Functions


Hi


I want to use a formula that will return the highest value in column 2

is there a way to do this please



Tags:

Answers

  • Maz Uddin
    Maz Uddin ✭✭✭✭

    @Genevieve P. hope you are well, can you please advise?

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭

    @Maz Uddin

    Can you clarify what you are looking to do?

    Are you looking for the first value in Column 2 alphabetically?

    Or are you looking for the highest value in Column 2 based on a value in another column?

    Your title question mentions using MATCH to find a person's name; what are you looking to match with, and what does a person's name have to do with the data in your screenshot?

    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

  • Maz Uddin
    Maz Uddin ✭✭✭✭

    @Jeff Reisman sorry I meant Max function

    i want to return the most common name in column 2 in another cell

    Bit of background, people nominating colleagues for an award, so i want to see who's been nominated the most.

    in the example above, G the is the most common so i want the formula to return G?

    can you advise please?

  • Jeff Reisman
    Jeff Reisman ✭✭✭✭✭✭

    @Maz Uddin Ah, that makes more sense!

    So you already know who has the most entries, that's good. We can use INDEX/MATCH with MAX to collect the name with the most entries. Just be aware that if two people have the same number of nominations, this formula will only return the first name it comes to (usually the name with the lowest row number that meets the conditions we give it.)

    =INDEX([Column2]:[Column2], MATCH(MAX([Column8]:[Column8]), [Column8]:[Column8], 0))

    In English: Give me the value from Column2 from the first row where the highest value in Column8 matches the value in Column8.

    Regards,

    Jeff Reisman

    Link: Smartsheet Functions Help Pages Link: Smartsheet Formula Error Messages

    If my answer helped solve your issue, please mark it as accepted so that other users can find it later. Thanks!

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!