I am looking to create a formula to pull data from a blank cell into the last cell with printed text. Here is the target output:

Currently I am using =INDEX(M4:M16,MATCH(TRUE,INDEX((M4:M16<>0),0),0)) which displays as this (below) - Should I be using a different method to try to achieve this or am I just setting some of the numbers wrong?

Many Thanks.

CodePudding user response：

=IF(INDEX(M:M,ROW() 1)="","",INDEX(M:M,MAX(IF((M:M<>"")*(ROW(M:M)<ROW()),ROW(M:M)))))

This will not throw the data for the final value, since it triggers if column M shows data in the next row. The logic for showing the last value is not defined and both your data and example try show different outcomes for that.