I have a list of different products (3000) going down column A.
Then going across I have periods 1-60.
The data are sales figures(see below example)
I need to figure out which period each product was introduced in. I was thinking an HLookup, but couldnt get it to work.
The ultimate goal is to get an average sales number after the first time the sales figures show up. There are periods after a product is introduced where 0 sales occur and I would like to include those in the average.
Period 1 2 3 4 5 6
Product
A 0 0 0 5 0 0
B 2 0 0 2 0 0
C 0 0 0 0 0 10
For I want to know for product A that it was introduced in period 4, and the average is 1.6 sales per year (5/3).
Any ideas of how I could accomplish this goal?
thanks everyone.
Then going across I have periods 1-60.
The data are sales figures(see below example)
I need to figure out which period each product was introduced in. I was thinking an HLookup, but couldnt get it to work.
The ultimate goal is to get an average sales number after the first time the sales figures show up. There are periods after a product is introduced where 0 sales occur and I would like to include those in the average.
Period 1 2 3 4 5 6
Product
A 0 0 0 5 0 0
B 2 0 0 2 0 0
C 0 0 0 0 0 10
For I want to know for product A that it was introduced in period 4, and the average is 1.6 sales per year (5/3).
Any ideas of how I could accomplish this goal?
thanks everyone.