F
Frank Kabel
Hi
enter the following formulas:
C2:
=MAX(MIN($B$2-(COLUMN(A:A)-1)*300,300),0)
and copy to the right:
C3:
=MAX(MIN($B3-(COLUMN(A:A)-1)*300+SUM($C$2:C2),300-SUM
(C$2:C2)),0)
and copy this to the right and down for all remaining
accounts
enter the following formulas:
C2:
=MAX(MIN($B$2-(COLUMN(A:A)-1)*300,300),0)
and copy to the right:
C3:
=MAX(MIN($B3-(COLUMN(A:A)-1)*300+SUM($C$2:C2),300-SUM
(C$2:C2)),0)
and copy this to the right and down for all remaining
accounts