compare of data from an excel file to the data in a loop

1 view (last 30 days)
Hello,
I have an excel file of 3 columns and 200 rows, I am comparing the result data from a loop to each of the data of the excel file to see their difference, lets say:
I need to read cell A2 for the for the first result of loop and if it A2 is larger than the result go to B2, and A3 for second result and so on.
Can you guide me how to do that?
  3 Comments
Shel
Shel on 28 Nov 2018
so can you please let me know how I can for example compare the B3 cell data with the second data of my loop?
Bob Thompson
Bob Thompson on 28 Nov 2018
If you load the entire array from the excel file into Matlab then comparing is just a matter of indexing. You can do this for each cell individually if you place the comparison within the loop, and then make the indexing be reactive to the change in loop index.

Sign in to comment.

Answers (0)

Community Treasure Hunt

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

Start Hunting!