Find rightmost non 0 number and then return row 1 for that column

[kdrexinger]

I have dates in row 1 and I am trying to find out what date contained the last reported number greater than 0.

My data starts in column E and goes to column X.

I have tried a variety of formulas but I can't seem to make it work and do not want to do a million if statements.

Thanks for any and all help you could provide!

[protonLeah]

What does "last reported number" mean?

[daffodil11]

Maybe something like this?
=LOOKUP(2,1/(E2:X2>0),$E$1:$X$1) and copy down?

[kdrexinger]

Thank you so much! This seems to be doing what I need!

[daffodil11]

Nothing like throwing a blind dart at the wall, and hitting the bullseye.