Try this:
=INDEX(2:2,,MAX(--(2:20)*COLUMN(2:2)))
It's an array formula, confirm it with Ctrl+Shift+Enter!
Regards,
Stefi

€žstew€� ezt Ã*rta:

Hi

I need a formula that will look along a row, to the left, and give me the
first number above zero

Thank you

Stew