ExcelNovice2017
New Member
- Joined
- Nov 29, 2017
- Messages
- 17
- Office Version
- 365
- 2021
- Platform
- Windows
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
<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
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