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.
1 回表示 (過去 30 日間)
古いコメントを表示
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
0 件のコメント
回答 (2 件)
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)
0 件のコメント
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
1 件のコメント
Stephen23
2015 年 1 月 4 日
Note that you should not use i as the loop variable, as this is the name of the inbuilt imaginary unit . This is poor coding practice in MATLAB.
参考
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!