C
CouchPotato
Hi, I am new to this forum and I hope I can find some answers to m
doubts. I have a series of data in "Data" tab and I would like t
summarise and split the series into periodical report (monthly an
quarterly) in "Call Summary" tab.
I have created 3 listed fields "Name", "Month" and "Quarter". I am stuc
with splitting the whole data series into monthly only (January
February, etc) and quarterly (Q1, 2, 3, 4). I have tried vlookup
hlookup, index and match but none worked perfectly. The reason I want t
split the data series into customised monthly and quarterly data is tha
I can select the particular ranges and automate the graphs only b
selecting the lists in any of 3 fields above.
Is there any way to make my life a lot easier with this report? Any hel
would be appreciated
+-------------------------------------------------------------------
|Filename: 2012 NOC stats.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=289
+-------------------------------------------------------------------
doubts. I have a series of data in "Data" tab and I would like t
summarise and split the series into periodical report (monthly an
quarterly) in "Call Summary" tab.
I have created 3 listed fields "Name", "Month" and "Quarter". I am stuc
with splitting the whole data series into monthly only (January
February, etc) and quarterly (Q1, 2, 3, 4). I have tried vlookup
hlookup, index and match but none worked perfectly. The reason I want t
split the data series into customised monthly and quarterly data is tha
I can select the particular ranges and automate the graphs only b
selecting the lists in any of 3 fields above.
Is there any way to make my life a lot easier with this report? Any hel
would be appreciated
+-------------------------------------------------------------------
|Filename: 2012 NOC stats.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=289
+-------------------------------------------------------------------