How to start analysing data from the highest value from excel?
1 view (last 30 days)
I have an excel file with all my data from different files, and I would just like to make it so that the data points I use for calculations start from the highest value of the data points.
experimentData = xlsread('Healthy_original.xlsx'); %Change for each experiment
for i=1:10 %start of loop
Is there a way to get it so that the highest value of the data is taken to be the first point, everything before the highest point is irrelevant.
Thanks for any help
Jos on 6 Dec 2014
I'm not entirely sure this is what you're looking for but I assume you want the vector 'a' within your for loop to start from the highest value in that particular column. To do this you can find the indices of the highest values in each column before the for loop
[~, indices] = max(experimentData(1:500,:));
then within the for loop you can use your data from the highest value by
a = experimentData(indices(i):500,1+i);