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

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.

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,136,616
Messages
5,676,835
Members
419,653
Latest member
analyticalchemist94

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