Help with simple MAX function

[Michelle senior]

Hi 

I'm driving myself nuts trying to work out how to return a max value from one column, based on a text string in another column - hope that makes sense. eg What is the max score for an "Apple"

Can anyone please help.  

Fruit	Score
Watermelon	1
Apple	2
Apple	3
Banana	4
Apple	5
Apple	6
Banana	7
Watermelon	8
Grape	9
Grape	10
Banana	11
Grape	12
Pear	13
Banana	14
Watermelon	15
Grape	16
Pear	17
Pear	18
Watermelon	19
Pear	20

[#2 · Accepted solution]

Hi Michelle,

If you are on O365 you may use MAXIF https://support.office.com/en-us/article/MAXIFS-function-dfd611e6-da2c-488a-919b-9b6376b28883. If not please check https://exceljet.net/formula/max-if-criteria-match

[#3]

Another Option you have is to use Pivot Table. it depends if you are looking for only one or a set.

[#4]

Hi Sergei, thank you very much, after a bit of work, I've finally got it to work!