Hey Guys,
I am somehow stuck in my vba macro . I am using Excel 2010. I have an excel List with measures for different days/month in different years (see attachment).
What I need is the following calculated in excel VBA in a cell the average and the slope for the year 2000, 2001, 2002, ...:
Year Average Slope
2000
2001
2002
...
Since my original table is pretty long it would be nice to solve that problem via vba.
Thanks a lot for any help.
Cheers,
Michael
I am somehow stuck in my vba macro . I am using Excel 2010. I have an excel List with measures for different days/month in different years (see attachment).
What I need is the following calculated in excel VBA in a cell the average and the slope for the year 2000, 2001, 2002, ...:
Year Average Slope
2000
2001
2002
...
Since my original table is pretty long it would be nice to solve that problem via vba.
Thanks a lot for any help.
Cheers,
Michael