Credit Payment Plan

An Excel file that teaches how to perform Credit Payment Plan operation.

Excel Credit Payment Plan

The DOLU numbers are determined by the array. The SON position is captured using the MAX function. The value is retrieved using the INDEX return. Spaces are safely skipped. Text and number scenarios are separated. The solution adapts to varying data sizes.

Hope it is useful.