Hi,
I have a data sheet with a lot of data spanning over several years and I need to summarize two columns (separately) for each month. The data sheet has 3 coloumns, one with the dates 2011-06-12, and two columns with the values. How do I do this? Is there any way Excel can recognize the change of months? (there are 11 stations á 7 years of data... so I really dont want to go about this one month at a time).
Any help on this would be greatly appreciated!
Anna
Bookmarks