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))))
I'm sorry, I don't understand what you mean. Can you provide more detailed information?
I'm working on a mortgage calculation worksheet and the column that will show the number of payments will vary in length depending on extra payments. I'm trying to capture that new number since it moves up that column. For example, for a std 30-year mortgage it will be 360 months and in row 360. If I make extra payments to pay off in 20 years it calculates 240 months, and the new value is in line 240. I want it to find that last value in a variable length column. I hope that helps explain.