M matmich Oct 3, 2005 #1 I have a list of dates, how can I get the subtotals for each month?? I only want to show the change in the month. thanks
I have a list of dates, how can I get the subtotals for each month?? I only want to show the change in the month. thanks
D Debra Dalgleish Oct 4, 2005 #2 You could use a pivot table to summarize the data, and group the dates by month. There are instructions in Excel's Help, and Jon Peltier has instructions and links: http://www.peltiertech.com/Excel/Pivots/pivotstart.htm To group the dates: http://www.contextures.com/xlPivot07.html
You could use a pivot table to summarize the data, and group the dates by month. There are instructions in Excel's Help, and Jon Peltier has instructions and links: http://www.peltiertech.com/Excel/Pivots/pivotstart.htm To group the dates: http://www.contextures.com/xlPivot07.html
