Latest Recv Date | 2017 | 2016 | 2015 | 2014 & Prior |
<tbody>
</tbody>
So I have a col G with a Date (Any date from 2012 to 2018). I need it to read such that,if the date in ColG is 2014 and prior then the value from Col Q goes into ol Y(2014 & Prior), else returns 0.
Alternatively, if date in Col G(I want tracking by year) is say 2017, I want the value to go to Col V, 2016 Value from Col Q to go into Col W etc