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.