Hi,

Looking for unique formula to allocate the past due amounts for customer
deliquency.

Col A = Monthly Payment
Col B = Total payments due
Col C = 30 days past due, Col D = 60 days past due etc. and goes up to Col H.

Col c thru h is not given. what is the unique formula for Col C thru H to
allocate monthly payments (maximum for each col) and adjust the remainder to
last column. (as per below example - col G is adjusted for 2 on first
customer and col F is adjsuted for next customer and Col H is (last col)
adjusted for last customer.

Thanks.

A B C D E F G H
5 22 5 5 5 5 2
17 55 17 17 17 4
20 140 20 20 20 20 20 40