Index Formula

[davidhall80]

I have a list of employee names in column A beginning at row 10.
Beginning in column D row 2, I have weeks 1 through 52 ending 52 columns later, but still in row 2. In these 52 columns, I have sales data underneath which matches with the employees in column A. I need to know the first week my employee made a sale. If an empoyee made a sale, it will show up under the corresponding week, if he didn't, it will be a zero. In column B next to thier name, I need to know what week was there first week of sales. What is there first week without a zero.

example



A................B........C..........D............E.........F.........G...........H........I.....

....................................Week1...Week2..Week3..Week4..Weeks..Week6


John..................................0...........0.......0..........$62...........0..........0

Sammy.............................0........$25.......0...........0..........82...........0

David................................0..........0.......0............0.........0............$37



John would be week4, sammy would be week 2 etc.....

 

[fairwinds]

Hi,

Try:

=INDEX($D$2:$BC$2,MATCH(TRUE,D10:BC10>0,0))

confirmed with Ctrl + shift + enter.

 

[davidhall80]

Thanks a million