Not sure which formula to use

[umzsexythang]

Hi all,
I have the following table set up:

Week1 Week2 Week3 Week4 Week5....
Store
A 1000 1350 45000 0 0
B 3000 322 0 0 0
C 2000 2000 2000 2000 2000

So week number across the top, store number down the side, and sales data in the middle. The weeks go to 52, and there are 450 stores. I want to have a formula at the end of each row which says what the first week number that has zero sales is
Thanks for your help[/code]

 

[Alto_HH]

Hello,

if your weeks are in row 1 and your data starts in B2 this formula will do:

=INDEX(B1:BA1,1,MATCH(0,B2:BA2,0))

Cheers

Alto

 

[ravishankar]

Hi
you can insert the formula in the last column of the row
="Week # " & MATCH(0,A2:BJ2,0)-1
Ravi

 

[umzsexythang]

Thank you, workd perfectly