Find max value with multiple conditions

How can I find max value with 2 or more conditions (such as maxifs in excel).

Thanks before

[darova]

You should attach more details, example

[Mohammad Sami]

If your data is table, create a grouping variable in your data. Then use the function groupsummary.

[Anita Fitriani]

Oh Im sorry for that. So I have data table of wave height. First data is year, the 2nd one is wave height, and the last one is direction. Then, I want to find the maximum of wave height but with spesific year and specific direction. Example, I would find the max of wave height in 2008 from North. If we use excel for this, we could use MAXIFS. And the result that I mean attached as picture here.

[Anita Fitriani]

[Andrei Bobrov]

Please attach small part of your excel-file or data table as MATLAB variable - 'table' in mat -file.

[Anita Fitriani]

This is small part of my wave height data

Answer 1

[Andrei Bobrov]

T=readtable('wave height data.xlsx');
[r,rn] = findgroups(T(:,1));
[c,cn] = findgroups(T(:,2));
out = accumarray([r,c],T.WaveHeight,[],@max);
Tout = array2table([rn.Year,out],'VariableNames',[{'Year'};cn.Direction]);

[Anita Fitriani]

Thankyou so much. It works!

[Andrei Bobrov]

Anita! If my answer solved your problem, then please accept it.

[Auwal Adamu Abdullahi]

How do i obtain and tabulate the maximum wave height. Add to that table two separate columns that show the direction and period of each of those yearly maximum wave heights. for 30 years?

Answer 2

[CAM]

Use logic statements for each criterion. Use logical "AND" (&) to see which elements meet all criteria. Find the max of those values.

Air Code (untested):

idxC1 = (matrix > criterion1);

idxC2 = (matrix < criterion2);

...

idxOverall = idxC1 & idxC2 & ... & idxCn;

MaxVal = max(matrix(idxOverall));