Macro last Instance of a value in a cell

[Floydlevedale]

Hi Excel Expert

I need help with a macro that will look/search for that last instance of a number in col B, and place it sequentially in col C, the cycle will restart, when the value in the cell of Col A is 1.

PFA workbook for further clarification.

Thanks in advance