Find the month of the last non-zero value in a row

[pliskers]

I have a database with a header row containing month-year periods, and rows of data showing sales within each period. The dates move from earliest to latest as you go from left to right.

On each row, I need a formula to the right of column Z (assume the data fills columns A-Z) that will deliver the value in the date header row that corresponds to the last non-zero (>0) value within that row, between columns A and Z.

Any help will be much appreciated!

 

[Haseeb Avarakkan]

See the post # 7.

 

[pliskers]

You're right, I was using the earlier formula. The one in #7 works fine. Thanks again.

 

[Aladin Akyurek]

How does the 9.99999999999999E+307 work?

Here are some links:

http://www.mrexcel.com/forum/showthread.php?t=102091

This one gives an explanation of the usage and how LOOKUP etc works with it:

http://www.mrexcel.com/forum/showthread.php?t=310278 (post #7)

 

[Aladin Akyurek]

You're right, I was using the earlier formula. The one in #7 works fine. Thanks again.

It's a smilar set up...

2 has the same function as 9.99999999999999E+307... Division by 0 eliminates effectively 0's qua numbers. See links quoted earlier.