How can i retrieve column based on cell values?
Show older comments
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
Accepted Answer
Jacob Wood
on 14 Feb 2020
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}};
More Answers (0)
Categories
Find more on Spreadsheets in Help Center and File Exchange
on 14 Feb 2020
on 18 Feb 2020
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!
