Forum Discussion
Excel help!
Thanks to SergeiBaklan​ I may now understand what you want. To get the last displayed value in column B, use
=INDEX(B1:B100, MAX(IF(($B$14:$B$100<>"")*(($D$14:$D$100>0)+($F$14:$F$100>0)), ROW($D$14:$D$100))))
Adjust the column in B1:B100 for the last displayed value in other columns, for example for column K:
=INDEX(K1:K100, MAX(IF(($B$14:$B$100<>"")*(($D$14:$D$100>0)+($F$14:$F$100>0)), ROW($D$14:$D$100))))
Thanks again for helping. I got all that in and now all I get is a 0. I've attached several screen shots of what I'm trying to do. In the beginning you will see $0.00 optional early payments and 360 actual total payments. Then I'll pay $25.00 in optional early payment, and it was reduced to 346 actual total payments and 347-360 are no longer visible.
Could you attach a small sample workbook demonstrating the problem (without sensitive data), or if that is not possible, make it available through OneDrive, Google Drive, Dropbox or similar?