Column Heading with first non-zero Entry

[mbdowty]

Row 1 contains headings (Q109, Q209......)
Row 2 contains sales figures.

What would a simple formula be that would return the heading where the first non-zero sales figure occurs?

Thanks

 

[schielrn]

This would work as an example, change the cell references as needed:

=INDEX(A1:H1,1,MIN(IF(A2:H2<>0,COLUMN(A2:H2))))

Book3
	A	B	C	D	E	F	G	H
1	Q109	Q209	Q309	Q409	Q110	Q210	Q310	Q410
2	0	0	0	15000	25000	26411	584656	531655
3
4
5	Q409
Sheet6

It also needs to be confirmed with control+shift+enter and not just enter.

Hope that helps.

 

[mbdowty]

Thanks Schielrn,

I wonder if there is a non-array formula solution. I have over 6000 rows of live sales data and I'm afraid the array formula will slow the workbook down too much.

 

[schielrn]

Maybe try:

=OFFSET(A1,0,MATCH(1,A2:H2))

Hope that helps.

 

[mbdowty]

Excellent, that is what I was looking for.