Hi, I am trying to create this Beginning Cost column using a multirow formula. I would like to take the Current Value at the beginning of every year and assign it to Beginning Cost, however there could be an unknown number of dates in a year, so just using IF [Row-1:Year] != [Year] THEN [Current Value] would not necessarily work unless you write out each row. Is there a better way to do this?
Ex.
| Date | Current Value | Beginning Cost |
| 01-01-2021 | 10000 | 10000 |
| 01-01-2022 | 8000 | 8000 |
| 03-01-2022 | 6500 | 8000 |
| 06-01-2022 | 6000 | 8000 |
| 01-01-2023 | 6000 | 6000 |
