Carry Over Balance and Bring Forward Balance Formula (Tough One!)

[ClericalOfficer]

Hi

In a long list with multiple employees, I have to track the carry forward balance and bring it forward if still some balance left.

Please see spreadsheet Illness Benefit Tracker (Test Sheet) and see cell I3. On I3 I want to bring forward the balance of Credits in cell H11. So, if employee 3534301 has multiple instances of illness benefit, at the first episode - rank 1.0 there is a credit of 5 days and the balance is carried over if any.

At the second instance for the same employee, if any credit left from the previous one, then bring it forward.

Chances are that 1 or 2 more tables will have to be created to track this.

Thanks for your help.
Illness Benefit Tracker (Test Sheet).xlsx

[JeteMc]

This will bring the value from cell H11 into cell I3 as requested:

Please Login or Register  to view this content.

Let us know if you have any questions.