Find a specific number in an imported excel sheet
2 views (last 30 days)
Show older comments
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!
0 Comments
Accepted Answer
More Answers (0)
See Also
Categories
Find more on Spreadsheets in Help Center and File Exchange
Community Treasure Hunt
Find the treasures in MATLAB Central and discover how the community can help you!
Start Hunting!