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

2019	2020	2021	2022	2023	2024	2025	2026	2027	2028	Recommended Year
6640	0	0	0	0	0	0	0	0	0	2019

<tbody>
</tbody>

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!