清空筛选条件
清空筛选条件

Find a specific number in an imported excel sheet

1 次查看（过去 30 天）
Tim
Tim 2017-10-19
评论： Tim 2017-10-19
Hey everyone, I have the matrix in the attached file and call it with
filename='Matrix.xlsx'
B=xlsread(filename)
Then I would give it a number for column A and a number which is in column B2 to I2. After that the result should be the Number in Row 1. For example: I give it 9 (A12) and 14.38 (B12) and the result should be 2 (B1). I thought about using the [row,col] function?
Thank you!

请先登录，再回答此问题。

采纳的回答

KL
KL 2017-10-19
[rowind,colind] = find(B(:,1)==9 & B(:,2:end)==14.38)
Do you mean this?

更多回答（0 个）

类别

在 Help Center 和 File Exchange 中查找有关 Data Import from MATLAB 的更多信息

标签

Community Treasure Hunt

Find the treasures in MATLAB Central and discover how the community can help you!

Start Hunting!

Translated by