I want to check a range for the last non-zero value in row 35 from columns R-AC. The value I want to return is the text that matches that column but in row 32. Using the first formula in my current data, it returns a value of 28 which is correct as that corresponds to column AB in this case. The second formula gives me "AB32" which is the cell I want to return. I tried adding the "cell" function in the third formula but it doesn't take as I have it written. Open to alternatives if there is an easier method.
Excel Formula:
=IF(COUNTA(R35:AC35)=0,"",MAX((R35:AC35<>0)*(COLUMN(R35:AC35))))
Excel Formula:
=SUBSTITUTE(ADDRESS(1, IF(COUNTA(R35:AC35)=0,"",MAX((R35:AC35<>0)*(COLUMN(R35:AC35)))), 4), "1", "")&32
Excel Formula:
=CELL("CONTENTS",SUBSTITUTE(ADDRESS(1, IF(COUNTA(R35:AC35)=0,"",MAX((R35:AC35<>0)*(COLUMN(R35:AC35)))), 4), "1", "")&32)