Akuini,

Not working on some cases.
This can be a little difficult to put into words, let me try explaining another way.
I have updated another sample with explanation in sheet :

Example 2 3.xlsb