In one column I have dates for the 2013 year and corresponding stock prices (for a large number of stocks). So the 2013 dates repeat each other in the one column for each new stock.
In another column I have "Change in price" using a (today-yesterday)/yesterday but when the year restarts the formula is redundant (first day of the year has no yesterday so needs to be blank, instead it uses the last day of the year of the above stock).
I figured the easiest way to do this is by mass deleting the cell adjacent to 01/01/2013. So it's like a Find All "01/01/2013", Delete but I need to offset it by 9 columns.
Thanks for help in advance.
n.b. each stock has different year lengths so I can't make a macros to delete every [n]th cell
Bookmarks