I have a spreadsheet of about 8000 rows of data and I need to average a column of data by the year in the correponding column. I would like to be able to drag the formula down to cover all years in the dataset. Any help would be greatly appreciated.
Ex.
C D E
2007 2 Column of averages by year
2007 1
2007 3
2006 2
2006 4
2006 1
2005 2
2005 3
Bookmarks