Littlemalky
Board Regular
- Joined
- Jan 14, 2011
- Messages
- 223
Ok, I need to be able to return the left-most cell value that is not a 0 so I can plug this into a CAGR calculation. I'm trying to work with a dynamic offset, but can't seem to get it to work properly to omit zero in the range. I need one formula that references the entire range of values in row 2. Row 1 represents the years.
Example, I need to be able to return 100 with a formula. However, if 2018 had a value other than zero, then I would need to return that instead. Any advice?
<tbody>
</tbody>
Example, I need to be able to return 100 with a formula. However, if 2018 had a value other than zero, then I would need to return that instead. Any advice?
2018 | 2019 | 2020 | 2021 | 2022 | 2023 |
0 | 100 | 200 | 300 | 400 | 500 |
<tbody>
</tbody>