Index Formula

davidhall80

Well-known Member
Joined
Jul 8, 2006
Messages
663
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.....
 

Excel Facts

What is the fastest way to copy a formula?
If A2:A50000 contain data. Enter a formula in B2. Select B2. Double-click the Fill Handle and Excel will shoot the formula down to B50000.

fairwinds

MrExcel MVP
Joined
May 15, 2003
Messages
8,638
Hi,

Try:

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

confirmed with Ctrl + shift + enter.
 

Forum statistics

Threads
1,172,017
Messages
5,878,757
Members
433,370
Latest member
mcleven

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top