I would like to find a way to complete the last column using a formula. The results should match year started column.
Any suggestions?
Any suggestions?
| Book1 | |||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
| A | B | C | D | E | F | G | H | I | |||
| 1 | Name | 2014 | 2015 | 2016 | 2017 | 2018 | Grand Total | Year Started | Year Started using formula | ||
| 2 | Name 1 | 18 | 18 | 2016 | |||||||
| 3 | Name 2 | 12 | 15 | 27 | 2017 | ||||||
| 4 | Name 3 | 29 | 42 | 71 | 2016 | ||||||
| 5 | Name 4 | 29 | 29 | 2018 | |||||||
| 6 | Name 5 | 12 | 12 | 2015 | |||||||
| 7 | Name 6 | 41 | 20 | 10 | 2014 | ||||||
Sheet1 | |||||||||||
