- I have list of assets
- There is information about buy date and buy value
- there is information about depreciation year
- I want to make the year of each deprecation and the depreciation value, be described yearly from top to down automatically
- I prefer array formula to prevent me from dragging the formula every now and then
here is the link of the case: https://docs.google.com/spreadsheets/d/1wJ65_Q3bD1Fz_ueW2cmQP_L03r8U2jvbMXstzzjMDb8/edit#gid=0
yellow cells are raw data green cells are expected form of output
thankyou in advance!