Hi all!
I have bi-annual data in a row and i want an annual average. How can I get the average for each year next to each other?
e.g. imagine a , is for a new cell, i would want this
SEMI ANNUAL DATA: 2,4,6,8,6,4,2,8
ANNUAL AVG: 3,7,5,5
So I hope it is clear that I want to skip some cells so that I do not get the average of e.g. second half of 2011 and the first half of 2012. I only want the averages of each year: so average of first half of 2011 and second half of 2011.
I hope its clear.
Daan
I have bi-annual data in a row and i want an annual average. How can I get the average for each year next to each other?
e.g. imagine a , is for a new cell, i would want this
SEMI ANNUAL DATA: 2,4,6,8,6,4,2,8
ANNUAL AVG: 3,7,5,5
So I hope it is clear that I want to skip some cells so that I do not get the average of e.g. second half of 2011 and the first half of 2012. I only want the averages of each year: so average of first half of 2011 and second half of 2011.
I hope its clear.
Daan