# Use Max function to return person's name?

✭✭✭✭✭
edited 04/13/22

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:

• ✭✭✭✭✭

• ✭✭✭✭✭✭

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

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

• ✭✭✭✭✭

@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?

• ✭✭✭✭✭✭

@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

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!