I have an excel file with data.
colom1: 1 2 3 4 5 empty empty 6 7 8 9 10 empty empty
What I want to do is this:
same for the next set of data (10-6 10-7 10-8 10-9), this for the entire colom.
With xlsread I read the file, then select the colom with num(:,x). I get an arraw with numbers then 2 Nanns between each set of data....
what then to do...
I used isnan and find. That gives me a new array with all the locations of the isnans.
1 2 3 4 5 NaN NAn
I get 6 and 7 as NaN... but how can I say if you find the 6th as NaN then use the 5th to calculate, 5-1 and 5-2 etc..