Creating a "spread" every time a dummy changes

Skjermbilde 2021-02-19 kl. 11.06.35.png

Hi

I would like to create a value for each time "type_id" changes between 0 and 1.
I want this value to be created by, for instance, subtracting price in C2 by C3, and the next value to be created by
subtracting C3 with C4.

However, There are instances where 0 or 1 appears more than once in a row. In these cases i would for instance like the "newest"
1 to create a value with the latest 0. An example of this is value created by C9 subtracted by C10, and then C9 subtracted by C11, and the C9 being subtracted by
C12, before C12 being subtracted by C13.

I have added a sample workbook with manually calculated desired results (Manual calculation of desired results)

Hope I was clear! Any help with this would be appreciated

Welcome to the forum.

There are instructions at the top of the page explaining how to attach your sample workbook.

Try pasting the following formula into cell G2 and copying down to cell G29:

Formula:

Please Login or Register  to view this content.

Let us know if you have any questions.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.

You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'.
Utilizing the Evaluate Formula feature on the Formulas tab may help with understanding what the formula is doing.
I hope that you have a blessed day.