Find a specific number in an imported excel sheet

2 vues (au cours des 30 derniers jours)
Tim
Tim le 19 Oct 2017
Commenté : Tim le 19 Oct 2017
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!

Connectez-vous pour répondre à cette question.

Réponse acceptée

KL
KL le 19 Oct 2017
[rowind,colind] = find(B(:,1)==9 & B(:,2:end)==14.38)
Do you mean this?
  1 commentaire
Tim
Tim le 19 Oct 2017
Thank you for your quick answer!

Connectez-vous pour commenter.

Plus de réponses (0)

Catégories

En savoir plus sur Data Import from MATLAB dans Help Center et File Exchange

Tags

Community Treasure Hunt

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

Start Hunting!

Translated by