How to read from one column of excel (from row 40 to 80) and can match it with the other column as well?

Hi Guys, I am trying to show five satellites in one plot.I have one excel file with 32 column and one of the column is related to time so I need to plot it in a specific time for ex, (5-10)ut. The problem is can not match the dimension of the rest matrix.

data=xlsread('1612_2.xls');

data_filterr=find(data(:,25)>60);

data_filtered=data(data_filterr,:);

elev_cutof20=find(data_filtered(:,6)>30);

data_cutoff15=data_filtered(elev_cutof20,:);

r=data_cutoff15(:,2);

time=(r./3600)-24*2;

s4r=data_cutoff15(:,8);

s4cor=data_cutoff15(:,9);

s4=sqrt(s4r.^2-s4cor.^2);

PRN=data_cutoff15(:,3);

I want to plot each PRN different color(satellite)in a certain time in a one figure. Could be for example, 5 PRN at that time.

Could you please help me?

[Ara]

Thank you, just one more thing. I really do not know from each row start the time for ex, 5ut so all I want to do is choose from time column those data are between 5-10 and then sort the rest of data as well.

Answer 1

[Pedro Villena]

 data = xlsread('1612_2.xls','A40:AF80');

[Ara]

Thank you, Pedro. I have another question regarding this, I would appreciate if you help me again. Please imagine I have a 90 data in one column that I want read only data from 1 to 40 and 60 to 90. So I do not know how to write it.

[José-Luis]

Read the entire range and select only the data you want afterwards. Alternatively, read twice, specifying a different range every time. Personally, I would go with the first option. Or you could use the activeX server, but for just one file and so little data, it's probably overkill.

[Ara]

Thank you, first option helped me.