Need help writing excel formula please

[MrBK]

Hello, I'm stuck writing a excel formula and need assistance and hopeful someone can help please!

I'm trying to write a formula that I can drag down column "P", that will analyze that row from (B:O) for the cell that has the first "1" in it, from left to right order, and return the header number listed in that column that's under the date in row 2. Thanks for your assistance!

Example 1: Row 3 has the first "1" in column "C" from (B3:O3), so it would return the header "13" in cell C2.
Example 2: Row 4 has the first "1" in column "B" from (B4:O4), so it would return the header "14" in cell B2.
Example 3: Row 5 has the first "1" in column "K" from (B5:O5), so it would return the header "5" in cell K2.
Example 4: Row 9 does not have a "1" in it from (B9:O9), so it would return a "0".

 

[MrBK]

 

[Peter_SSs]

Welcome to the MrExcel board!

I suggest that you investigate XL2BB for providing sample data to make it easier for helpers by not having to manually type out sample data to test with.

See if this helps

20 11 25.xlsm
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
1
2	14	13	12	11	10	9	8	7	6	5	4	3	2	1
3		1	1	1						1					13
4	1	1					1								14
5										1					5
6															0
7												1	1	1	3
First 1

Cell Formulas
Range	Formula
P3:P7	P3	=INDEX(FILTER(B$2:O$2,B3:O3=1,0),1)

 

[MrBK]

Thanks for the assistance Peter!

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.