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" C...
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
Another Option you have is to use Pivot Table. it depends if you are looking for only one or a set.