Show Cost Year

[ExcelNovice2017]

Good Afternoon All

I was hoping you could help with the below example, which I'm sure is fairly simple but I'm not sure where to start

[TABLE="width: 500"]
<tbody>[TR]
[TD]2019[/TD]
[TD]2020[/TD]
[TD]2021[/TD]
[TD]2022[/TD]
[TD]2023[/TD]
[TD]2024[/TD]
[TD]2025[/TD]
[TD]2026[/TD]
[TD]2027[/TD]
[TD]2028[/TD]
[TD]Recommended Year[/TD]
[/TR]
[TR]
[TD]6640[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]0[/TD]
[TD]2019[/TD]
[/TR]
</tbody>[/TABLE]

I was hoping to use a formula in the recommended year, that says pick any value above '0' and show the year that value sits in

They will only ever be one value above 0

Any help would be much appreciated

 

[Scott T]

Book1
	A	B	C	D	E	F	G	H	I	J	K
1	2019	2020	2021	2022	2023	2024	2025	2026	2027	2028	Recommended Year
2	6640	0	0	0	0	0	0	0	0	0	2019
Sheet1

Cell Formulas
Range	Formula
K2	=INDEX(A1:J1,MATCH(MAX(A2:J2),A2:J2,0))

 

[sheetspread]

=SUMPRODUCT(--($A$2:$J$2<>0),$A$1:$J$1)

works too

 

[ExcelNovice2017]

Thank you that works a treat, appreciated the very quick response!