reading values

I have some data ,i tried using xlsread ,but final column is not dsiplaying

A=

12 36 45 858 8 1 >50

10 2 1 21 20 0 <=50

like these i have 30000 rows and 6 columns,now i want to read all the column and store the last column in separate variable,please help

[Image Analyst]

What is that? That is not MATLAB code.

Answer 1

[Image Analyst]

How about this:

separateVariable = array2D(:,end);

[kash]

what is array 2D,can u tell oe to from excel

[Image Analyst]

That's your array of 30000 rows and 6 columns. Obviously it might not be called array2D - your actual 2D array in your program may have a different name, right? What is the name of it? Let's say you called it M, and let's say you want the separate variable to be called lastColumn instead of separateVariable. Then you'd simply replace array3D in my code with M, and separateVariable in my code with lastColumn, like this:

lastColumn = M(:, end);

Hopefully that's explicit enough to help explain it in a different way - a way that you can understand. If you still don't understand then say so and post your code. But you still didn't explain what this means:

10 2 1 21 20 0 <=50

[kash]

column1 colmun2 column3 column4 column 5 column6 column7

10 2 1 21 20 0 <50

these i have stored as dataset.xls

now i want to read all datas and display

next i want last column to be stored in separate variabe ,

then in that last column i want to count how values are there

which is >50,<=50

[Image Analyst]

Do what I said then. The to get the sum of the number of elements where the value <= 50:

summedUp = sum(lastColumn<=50);

Answer 2

[Walter Roberson]

How did you do the xlsread() ? That final column is going to be discarded (or 0 or NaN) in the (default) numeric output, available only in the second (text) output or third (raw) output.