How to calculate the first cell address from RIGHT to LEFT that is greater than 0 or not BLANK

[CraigThompson]

Hello,

I'm using the formula below which returns the cell from the left where the first number is greater than zero or not a blank. What I need to do is the same in reverse (from RIGHT to LEFT). I just can't seem to make anything work. Please help. TIA!

=CELL("address",INDEX(C4:M4,MATCH(TRUE,C4:M4>0,0)))

 

[Fluff]

Hi & welcome to MrExcel.
How about

=ADDRESS(ROW(),TAKE(FILTER(COLUMN(C4:M4),C4:M4>0),,-1))

 

[CraigThompson]

Hi & welcome to MrExcel.
How about

=ADDRESS(ROW(),TAKE(FILTER(COLUMN(C4:M4),C4:M4>0),,-1))

Wow! That's works great. Thank you so much

 

[Fluff]

You're welcome & thanks for the feedback.