How to compare the first row first column value to the first row second column value in excel . eg: 3 4, 5 6, 7 8 : i need to compare 3 with 4 then assign 2 to that row ie., which column has high value that column number is assigned to that row.

2 次查看（过去 30 天）
kavitha subramaniam
kavitha subramaniam 2014-12-18
评论： Stephen23 2015-1-4
eg: 2 3 4 5 6 7 9 8 output: 2 2 2 1 working 2 is compared with 3 2nd column value is high so for that row value assigned is 2 lly, 4>5,so final value=2 6>7, final value=2 9>8,final value=1

请先登录，再回答此问题。

回答（2 个）

Andrei Bobrov
Andrei Bobrov 2014-12-18
编辑：Andrei Bobrov 2014-12-18
a = [2 3
4 5
6 7
9 8]
out = 1 + (diff(a,1,2)>0)
OR
[~,out] = max(a,[],2)
Gaurav Shukla
Gaurav Shukla 2014-12-18
I did not get the use case of the question however , the following code does exactly what u need. Hope this helps.
cnt=1;
a=[2,3,4,5,6,7,9,8];
for i = 1:2:length(a)
if(a(i)>a(i+1))
b(cnt)=1;
else
b(cnt)=2;
end
cnt=cnt+1;
end

类别

在 Help Center 和 File Exchange 中查找有关 Mathematics 的更多信息

标签

Community Treasure Hunt

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

Start Hunting!

Translated by