Forum Discussion
Solved
Help with simple MAX function
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 |
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 Replies
- Another Option you have is to use Pivot Table. it depends if you are looking for only one or a set.
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
Hi Sergei, thank you very much, after a bit of work, I've finally got it to work!
