A compact way to find max in one column with a condition on the second column

2 views (last 30 days)
Given
a = [35 -1
21 1
11 2];
I want the max in the first column, but the max cannot be that one where there is a "-1" in the second column.
Therefore the correct answer is not "35" (since in the second column there is "-1"), but "21".
Do you know a compact way to get this max in the first column, with the condition on the second column ?

Accepted Answer

Bruno Luong
Bruno Luong on 7 Oct 2022
a = [35 -1
21 1
11 2];
max(a(a(:,2) ~= -1,1))
ans = 21
  3 Comments
Bruno Luong
Bruno Luong on 7 Oct 2022
If you want to get row index of the max value:
a = [35 -1
21 1
11 2];
filteridx = find(a(:,2) ~= -1);
[maxvalue, maxidx] = max(a(filteridx,1));
maxidx = filteridx(maxidx)
maxidx = 2

Sign in to comment.

More Answers (0)

Categories

Find more on Matrices and Arrays in Help Center and File Exchange

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!