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

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

[Mimie Basha]

here the attchment.............forget to attch

Answer 1

[Geoff Hayes]

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?

[Mimie Basha]

tq brother geoff

Problem: i want to compare all value for column red and green with one value. for exampale i already decide the value is 200, so when any value in column red or green exceed 200, counter will increase 1...

so i can count the number of spot which is the value exceed 200...:)

[Mimie Basha]

i want to compare all value in column H with value 100....if value H exceed value 100, counter will increase 1.. :)

lastly, result i need is total of counter. :)

[Geoff Hayes]

Mimie - see the find for how you can determine which elements of your vector exceed some threshold. For example, if hData is your column H and you wish to know how many elements exceed 100 then

 find(hData>100)

will return all row indices of hData whose element is greater than 100. Now use length to determine how many rows of hData exceed this threshold

 length(find(hData>100))