I have this formula in excel 2019 to check the last non-empty title in row :

=IFNA(INDEX($BZ$1:$CN$1,MATCH(TRUE,BZ4:CN4<>"",0)),"No Data")

but it’s return only the first non-empty cell from right(my table is from right to left) not the last non-empty cell to the left, fro example : the title row is starting from BZ1 to CO1 and data row starting from BZ3 to CO3, and the cells CE3, CC3 and CA3 has values, the formula will give me only the CA3 title, not the CE3, so, how can i modife the formula to give me last title for non-empty cell (if i put value in CN3 it will give me the title of CN3 cell not the CA3)

I tried the formula and it’s give me the first cell title from the right only, not the last one