How can i retrieve column based on cell values?

I just stored my data from matlab to excel file using xlswrite , looks like this..but i have no idea to query column name based on cell values..

for example if my threshold is = 1.6155 then it will retrieve column name such as = "Merah Ma , Kuning, Hijau"

return the column name values where cell values greater than 1.6155

Answer 1

[Jacob Wood]

You can accomplish this with logical indexing. See below for an example:

d = {'Putih','Abu-abu','Hitam'; 0.014149,0.04175,0.081601};
thresh = 0.02;

idx = [d{2,:}] > thresh;
col_names = {d{1,idx}};

[Mochammad Fariz]

thank u mate

[Mochammad Fariz]

could you help me Jacob?? i don't have idea query column based on column..this is my link of question

https://www.mathworks.com/matlabcentral/answers/506096-how-can-i-query-last-column-based-on-another-values-column