First of all, here's the sample sheet:
https://filetransfer.io/data-package/YvwqMbpW#link
(I cannot upload it here. ExcelForum, please fix the attach button as it doesn't work. Tried with Opera and Chrome)
So we have a set of numbered blocks like these:
22284676
22296196
22307716
22319236
22330756
22342276
Think of them like epochs, representing specific times at which the "Reset Event" take place.
As you can see, they come with the same consecutive "Reset Lenght" increments => 11520.
As an example, the first "Last Known Reset" is 22284676 + 11520 = 22296196 (which is the next reset) and so on.
Now here's the problem:
We want to know the next reset number/block based on a Known Reset PLUS a current arbitrary starting block.
How do we do it with a formula?
Note: I asked a similar question using time on the link below. Maybe the answer could help solve this one too.
https://www.excelforum.com/excel-for...ultiplier.html
Bookmarks