Hello,
I am trying to come up with a formula. I have a schedule for a 5 year forecast of new products. Crude outline below.
A B C D E F G H I J K
1 X X X $ $ $ $ $ $ 0 0
2 X X X 0 $ $ $ $ $ 0 0
3 X X X 0 0 $ $ $ $ $ 0
Columns A-C are product information. Starting in Column D, there is sales data. As it goes down the rows, the sales start year will extend past row D. In column L, I want to come up with a formula to calculate the first year with $ amounts in the row series. I want it to be automatic. In column M, I also want to calculate the year with $ amounts so I can calculate a growth rate.
Any ideas?? Thanks!
I am trying to come up with a formula. I have a schedule for a 5 year forecast of new products. Crude outline below.
A B C D E F G H I J K
1 X X X $ $ $ $ $ $ 0 0
2 X X X 0 $ $ $ $ $ 0 0
3 X X X 0 0 $ $ $ $ $ 0
Columns A-C are product information. Starting in Column D, there is sales data. As it goes down the rows, the sales start year will extend past row D. In column L, I want to come up with a formula to calculate the first year with $ amounts in the row series. I want it to be automatic. In column M, I also want to calculate the year with $ amounts so I can calculate a growth rate.
Any ideas?? Thanks!
