Go Back   TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



How to convert monthly data into quarterly data in Microsoft Excel

MS Office Support


Reply
 
Thread Tools Search this Thread
  #1  
Old 31-12-2011
Member
 
Join Date: Dec 2011
Posts: 4
How to convert monthly data into quarterly data in Microsoft Excel

Is there an easy way to convert a column of monthly data into a column of quarterly data (average of months in the quarter)?

Reply With Quote
  #2  
Old 31-12-2011
Member
 
Join Date: Aug 2011
Posts: 459
Re: How to convert monthly data into quarterly data in Microsoft Excel

You can try to do this : =SUM(OFFSET($M$3,ROW()*3-9,0,3,1)). Replace $M$3 with the cell address of the first month's data. Replace the 9 with 3* for the row number of that first month's data (my example was in row 3; 3*3=9). Autofill that formula down through three more rows.
Reply With Quote
  #3  
Old 31-12-2011
Member
 
Join Date: Jul 2011
Posts: 432
Re: How to convert monthly data into quarterly data in Microsoft Excel

To group date fields, you can select the field on your ACT, then right-click context menu, then you select "Group", and you choose your month quarter year period or another in the window that appears. The first date must be an end of quarter. The formula shifts the previous date of 4 months and is placed on day 0 which is the last day of previous month.
Reply With Quote
  #4  
Old 04-01-2014
Member
 
Join Date: Aug 2011
Posts: 561
Re: How to convert monthly data into quarterly data in Microsoft Excel

You have to understand the proper formula to get result. In a year there are around 3 quarters. This are divided in the gap of 4 months. So first you have to find out the month average which will be considered on the basis of 3 quarters. You have to begin with numbering each and every month. You can insert a column and start doing the same. Then you can try moving ahead to pull out a quarterly data from the same. You will need to use vlookup.
Reply With Quote
  #5  
Old 04-01-2014
Member
 
Join Date: Aug 2011
Posts: 459
Re: How to convert monthly data into quarterly data in Microsoft Excel

This can be done by locating three months average first. We are going to take 3 quarters of a year under consideration. You can add a extra column and use it for getting three months average. A single cell in that new column will give you the average of 3 months. You have to decide the months here. Then you go ahead with using vlookup to get final output. This is a bit complicated but I found a video on the same on YouTube. You can try searching the same.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Office Help > MS Office Support


Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "How to convert monthly data into quarterly data in Microsoft Excel"
Thread Thread Starter Forum Replies Last Post
Need help to convert monthly data to Quarterly in Microsoft Excel ELETTRA| MS Office Support 2 17-02-2012 02:06 PM
How to convert Daily DATA in Excel into Monthly, Weekly and Yearly aMADeO! MS Office Support 3 13-01-2012 04:57 PM
How to convert Excel file data into XML code Arif15 Software Development 3 20-10-2009 07:21 PM
Convert Excel data to HTML Table Chalina Software Development 2 04-08-2009 11:21 PM
How to graph daily data in to monthly excel sheet Sunny55 Windows Software 2 04-06-2009 08:32 PM


All times are GMT +5.5. The time now is 11:55 PM.