num1 = xlsread('Smart_meter_data.xlsx', 'B2:AW93');
num2 = xlsread('Smart_meter_data.xlsx', 'AX2:AX93');
I have an excel file that is 92 rows of 48 columns of measured values, and the 49th column are the ID numbers for what is being measured in each row. How do I write an 'if statement' to see if each row contains measurements above a certain value, and if it does then the corresponding ID number in the last column is true? Logically I'm trying to do something like this, but this obviously isn't a working syntax.