MATLAB: I want to retrieve every data from the table (as atachment) in column red and green

comparisonretrieve

I want to retrieve every data from my table (as atachment) in column red and green….and compare to one value (as condition) and counter if value correct for the condition…..do you have any suggesstion code?…tq

Best Answer

Mimie - see xlsread for how you can read in the data from the spreadsheet, and in particular, the red and green columns. For your case, you may want to do something like
filename = 'microarrayMimie.xls';
firstPair = xlsread(filename,'E:F');
secondPair = xlsread(filename,'H:I')
where you read in two columns at a time, those in E and F, and those in H and I.
Your next step is that you want to compare to one value. Please elaborate - which elements of the columns are you comparing, and to what?