Identifying Zero-to-Non-Zero Value and vice versa

[nsturk725]

Hi Guys -

Can someone help me with the following

[sample data attached]

What I Need To Do:
Phase In

Where a cell is zero, check to see if the cell values up until "Nov" are not zeros. (DO NOT INCLUDE "TTL")
If there are no zero values in that range (to the right of the zero), return the "month" of the cell where it first started not to be zero (the cell to the right of the zero), to the respective "Month of Action" row-cell.

Example = the first data row "month of action" value would be "Aug"
= the last row "month of action" value would be "Nov"

[ I need to detect where a cell first turns from a zero to a positive number and remains a non-zero value through "Nov"]


Phase Out
(the reverse of above)

For each row, if there is a cell with a zero, check to see if the values through "Nov" are zeros as well.
If they are zeros, return the "month" of the cell where the first zero started.

Example = the second data row "month of action" value should be "Oct"

[I need to detect where a positive number turns to a zero and remains a zero through "Nov"]


Thank you very much for any help you guys can provide.

See sample attachment