I need to turn weekly data into monthly averages. I would like calculate each variable into monthly averages all at once. The first row is the title of the variable after that the data starts. How can I do this and keep everything neat so that I can move it into another software program?
I am not very savy with excell, anything helps!
Date in the format month/day/year.. I could format to be Month-year Variable1 Variable2 Varible3 Variable4 Variable5
Hi Insert Name and welcome to the forum.
You need to learn about Pivot Tables and grouping. Read http://chandoo.org/wp/2009/11/17/gro...-pivot-tables/ or
http://www.fanhow.com/knowhow:Group_...Excel_35510038
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Another good source to learn about Pivottables is here:
http://www.datapigtechnologies.com/ExcelMain.htm
Last edited by olasa; 07-09-2012 at 04:56 AM. Reason: typo
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks