thanks a lot for the answer!!! sure I will explain better:

nothing, i am not interested in the missing interval but I have to fill it somehow in order to give it consistency so it can be filled with the value 'mean pressure' of the above interval, in this case, the missing interval
06:21_06:52
?
08:14_08:31
can be filled with 1019,25

and here lies the challenge.... the rule is that I am only interested to apply the value "mean pressure" in the 'pressure' tab into the 'results' tab , and only apply the the available value (1019.25) within the same time frame, and the missing time gab, can be filled with the value before or after...

another issue : I was also looking for a way to reduce the number of points in the tab 'results' , basically i just want to have 1 value per minute , and erase the duplicates..... any suggestions about this too? I tried with this =IF(MOD(ROW()-ROW(C$1),$D$1)=0,B6,NA()) which basically puts the value from column B into column C at the frequency indicated in cell D1, and as in my case, there are 6 entries per minute, i put 6... the problem is that it delivers repeated date cells every x interval... quite a pain... I tried also with an advanced filter, to remove duplicates... didnt work.

Dear Contrucci, Good Evening.

The data columns "draft" and "pressure" at your tab "results" are automated now.

Take a look at it and tell me if it worked for you.

http://www.4shared.com/zip/gcXfQGP1/...er_HELP_T.html


Have a nice day.

[quote=Mazzaropi;1601683]Dear Contrucci, Good Evening.

The data columns "draft" and "pressure" at your tab "results" are automated now.

QUOTE]

thank you Mazzaropi!!! that work perfectly, how did you do that?

if I have more entries of pressure or draft I just drag down the blue grid right?

thanks again! :)

Mazzaropi, actually I have another question, would it be possible to set the spread**** in such a way that the tab "results" will reflect only the data where there are values for the pressure?

in our exampe, I am interested to deliver data only from 00:00 to 13:19 (in tab "pressure", SOL and EOL times)

thanks again!

Dear Contrucci, Good Afternoon.

I´m not sure if I understood your new question.

Could you give me some example about what are you intending to receive.
Please attach a little part of the worksheet.
It´s easier to understand.