How to find a specific number in a specific column in an excel file and how many times it occurs
2 ビュー (過去 30 日間)
古いコメントを表示
Hi, I have been looking around for a solution to this problem, I have an excel file and it contains the number -1100 in the column with header "T". I want to find out how many times this number occurs in this given column. So I tried
[~, ~, data] = xlsread('test.xlsx');
data = string(data); % convert to string for easy comparision
rowsIndex = data(:, 1) == "T" && data(:, 2) == "-1100";
requiredRows = data(rowsIndex, :);
but this does not work. How can I find the number of times it occurs in the T column?
Thanks
2 件のコメント
採用された回答
VBBV
2024 年 1 月 31 日
D = readtable('test.xlsx');
rowsIndex = D.T == -1100;
requiredRows = D(rowsIndex, :)
4 件のコメント
その他の回答 (0 件)
参考
カテゴリ
Help Center および File Exchange で Spreadsheets についてさらに検索
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!