How can i query last column based on another values column

i have excel database consisting percentage values from column 1-27..my question is how can i query last column (file path of an image / column 28) based on threshold..for your information my threshold is = 1.6155 from column 1-27

[Bhaskar R]

From where you get from the threshold value?

[Mochammad Fariz]

i try some images to know threshold how much minimum value percentage of color to display in image..for example the image contains red,yellow,blue,green, and brown ..

red = 14.08888

yellow = 1.5554

blue = 30.8775

green = 0.8755

brown = 0.2377

then in GUI matlab will show " this image contains blue,red "

Answer 1

[KSSV]

You can use inequalitites ==, >, <, >=, <=. Read about them.

Read the excel data into MATLAB using xlsread or readtable.

If A is your column, and val is your value 1.6155.

% get values less then val 
idx = A<val ;   % this gives logical indices which are less then val
A(A<val)     % this gives values which are less then val 

[Mochammad Fariz]

this is my current code

[Mochammad Fariz]

but i dont have idea how query column based another range on column

[KSSV]

YOu should use num. That is the matrix of numbers....pick a column from there.

C1 = num(:,1) ;   % gives first column
C7 = num(:,7) ;   % gives sevent column 

[Mochammad Fariz]

but if i use num i can't query string of path in last columns

[KSSV]

Get the indices from num..and use those indices to querry the string column....

[Mochammad Fariz]

could you give me some codes to query last column (string path name) based on (column 1-27 percentage name)like i describe in my picture database excel above??

[KSSV]

get the last column by using

iwant = raw(:,end) ;