Translating values over time

[tax112]

Hi everybody.
I have a complicated math problem. As follows:
At the time points: 00:00, 00:05, 00:10, 00:15,....(multiple of 5), the data before and after does not change.
In addition to the above milestones, it changes, based on the time of 2 landmarks.
Please see attached file.
Can someone research and help me solve this complex problem.
Thank you.

[jindon]

Please Login or Register  to view this content.

[tax112]

Thank you Mr. Jindon
First of all, I apologize for not being clear and not checking the demo file carefully.
I would like to send back the file and the desired content.
Thank you.

[jindon]

Still not clear.

You said
"Begin: 00:00 to 00:05, Decreasing value."
"Begin: 00:15 to 00:20,Incremental value."
Waht about others?

[tax112]

@jindon.
Yes, that's what I took as an example.
My problem is to consider the first and last two landmarks.
If the starting point data is larger than the end point data, then the values are decremented.
If the starting price is less than the end point, the values increase.
The result is the same as the Demo file.

[jindon]

I wrote the code according to your data set of before/after. and you only have up to 2022/1/1 0:15:00.

I don't think I understand why you are trying to say, unless you upload your complete results that you want.

[tax112]

@jindon:
I assigned the desired result to File.
I also checked the file again.
Can you please write vba code for me.
Thank you.

[jindon]

Decrease 00:00 to 00:14, Increase 00:15 to 00:24, Decrease 00:25 to 00:29.
so, no logical interval?

[tax112]

@jindon:
My data is huge.
So I just included some demo values.
The key to the problem is to compare two time points so that there are translational values that increase or decrease.
You try to research for me.
Thank you.

[jindon]

Did you want to say that

Check each 5 minutes and if it is increasing, increase, otherwise decrease.

Please Login or Register  to view this content.

[tax112]

@jindon:
Exactly.
Thank you very much.