| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
From Monthly to Quarterly Numbers
I have many years of by month data listed in columns. I would like to start a new sheet that adds 3 months of data into a quarterly column. That is it would add the the first 3 months of a year for Q1, then take months 4,5,6, for Quarter 2, months 7,8,9 for Q3 etc. and be able to move the data to the new sheet automaticaly. Any ideas much appreciated. Thanks Jake -- jgorman ------------------------------------------------------------------------ jgorman's Profile: http://www.excelforum.com/member.php...o&userid=33081 View this thread: http://www.excelforum.com/showthread...hreadid=528933 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert monthly data into quarterly data? | Excel Discussion (Misc queries) | |||
| VLOOKUP should compare numbers stored as text to plain numbers. | Excel Worksheet Functions | |||
| How do I convert monthly data to quarterly data? | Excel Discussion (Misc queries) | |||
| Excel - sum a column of sales monthly and quarterly? | Excel Worksheet Functions | |||
| Sorting when some numbers have a text suffix | Excel Discussion (Misc queries) | |||
Threaded Mode
