I have my data in, say row A - specifically A1:A50 - and want my calculation
to look from the bottom of A50 to the top of the row (A1) and return the
first non-blank OR the first non-zero within that data.

What is the best way to do this?

E.g.
A1 = 4
A2 = 3
A3 = 0
A4 = blank cell
A5 = blank cell

Answer would be 3 as it looks from the bottom.

Many thanks,

Jim