|I'm a bit confused.|
Your number codes are in AN14:AN113 but your dates are in E12:E113.
That's 2 less rows of dates than numbers. Is that correct?
What version of Excel are you using?
If it's 2007 or later, try this:
Add another column (often called a Helper Column, which you could hide) to extract the Year from the dates in E12:E113.
e.g. in F12 enter =YEAR(E12) and drag it down to F113
Then you can use this formula for your percentages:
e.g. for the number 1:
Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.