Use Max function to return person's name?

MazU

Hi

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

is there a way to do this please

MazU

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

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?

MazU

@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

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