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 vue (au cours des 30 derniers jours)
Afficher commentaires plus anciens
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 commentaires
Réponses (2)
Andrei Bobrov
le 18 Déc 2014
Modifié(e) : Andrei Bobrov
le 18 Déc 2014
a = [2 3
4 5
6 7
9 8]
out = 1 + (diff(a,1,2)>0)
OR
[~,out] = max(a,[],2)
0 commentaires
Gaurav Shukla
le 18 Déc 2014
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 commentaire
Stephen23
le 4 Jan 2015
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.
Voir également
Catégories
En savoir plus sur Multidimensional Arrays dans Help Center et File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!