Finding the Last Value in a Row and Column

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

Excel Finding the Last Value in A Row and Column

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.