How to group by month

[15minoffame]

Hi,
Can anyone help me group all Jan, Apr, July, Oct data together? The following data starts in column A.

Tue 01/26/2016 AC <tbody> </tbody>	$99.99	$96.04	-3.95%	-6.57%	-2.65%	-2.65%	-3.64%	-4.98%	-3.35%	-3.30%	5.92%
Tue 10/27/2015 AC	$114.55	$117.58	2.64%	4.12%	4.32%	4.32%	6.50%	5.25%	-0.75%	3.27%	-6.30%
Tue 07/21/2015 AC	$130.75	$121.99	-6.69%	-4.22%	-4.78%	-4.78%	-5.93%	-9.41%	-13.20%	-21.13%	-11.80%
Mon 04/27/2015 AC	$132.65	$134.46	1.36%	-1.57%	-5.65%	-2.78%	-5.16%	-3.79%	-1.85%	-1.78%	-4.56%
Tue 01/27/2015 AC	$109.14	$117.62	7.76%	5.65%	7.34%	7.34%	9.54%	9.69%	17.12%	18.27%	16.55%
Mon 10/20/2014 AC	$99.76	$103.02	3.26%	2.71%	5.08%	5.47%	6.99%	8.25%	9.09%	16.75%	9.99%
Tue 07/22/2014 AC	$94.72	$95.42	0.73%	2.60%	3.11%	3.11%	3.62%	0.91%	1.31%	7.20%	7.29%
Wed 04/23/2014 AC	$74.95	$81.17	8.28%	8.20%	8.99%	13.21%	12.71%	13.27%	13.17%	19.22%	-82.45%
Mon 01/27/2014 AC	$78.64	$72.68	-7.57%	-7.98%	-9.21%	-9.06%	-7.57%	-5.59%	-1.18%	-4.40%	-3.20%
Mon 10/28/2013 AC	$75.70	$76.61	1.20%	-2.49%	-1.35%	-1.85%	-0.83%	-1.75%	-2.12%	4.94%	3.61%
Tue 07/23/2013 AC	$418.99	$438.93	4.75%	5.13%	5.25%	5.25%	8.00%	12.04%	16.84%	20.04%	7.42%
Tue 04/23/2013 AC	$406.13	$393.54	-3.09%	-0.16%	2.72%	2.72%	8.16%	13.43%	9.29%	9.60%	6.36%
Wed 01/23/2013 AC	$514.00	$460.00	-10.50%	-12.35%	-14.42%	-12.48%	-11.38%	-10.92%	-9.14%	-12.65%	-11.57%
Thu 10/25/2012 AC	$609.54	$609.42	-0.01%	-0.90%	-0.90%	-0.90%	-5.37%	-8.45%	-13.76%	-4.36%	-13.65%
Tue 07/24/2012 AC	$600.91	$574.46	-4.40%	-4.31%	-2.62%	-2.62%	0.98%	3.59%	5.12%	12.44%	16.45%
Tue 04/24/2012 AC	$560.28	$615.64	9.88%	8.87%	7.62%	7.62%	4.58%	1.64%	-1.26%	0.35%	4.55%
Tue 01/24/2012 AC	$420.41	$454.44	8.09%	6.24%	6.39%	6.39%	8.51%	10.36%	21.18%	25.05%	42.97%
Tue 10/18/2011 AC	$422.24	$401.35	-4.94%	-5.59%	-6.95%	-6.95%	-5.12%	-4.13%	-3.79%	-12.60%	-7.19%
Tue 07/19/2011 AC	$376.85	$396.12	5.11%	2.66%	4.36%	4.36%	4.17%	5.28%	-0.75%	-5.41%	0.81%
Wed 04/20/2011 AC	$342.41	$355.00	3.67%	2.42%	2.42%	3.09%	1.26%	1.69%	1.40%	-2.98%	-2.91%
Tue 01/18/2011 AC	$340.65	$348.35	2.26%	-0.53%	-4.08%	-4.08%	0.93%	-0.39%	4.27%	2.90%	3.78%
Mon 10/18/2010 AC	$318.00	$303.39	-4.59%	-2.67%	-2.66%	-3.31%	-3.12%	-5.35%	0.19%	-3.54%	0.80%
Tue 07/20/2010 AC	$251.89	$265.08	5.24%	0.93%	3.19%	3.19%	3.60%	3.95%	2.98%	-2.41%	6.01%
Tue 04/20/2010 AC	$244.59	$258.80	5.80%	5.98%	10.72%	10.72%	6.95%	8.89%	4.87%	0.88%	3.96%

<colgroup><col><col span="11"></colgroup><tbody>
</tbody>

Thanks again!

 

[Joyner]

What do you mean by "group"? For each date in column A that is Jan, add all of the numbers in the individual columns? Even the percentages?

If the Dates in column A are actual dates, you can easily use a Pivot Table to group by month. It that is what you want to do and you don't know how to use a Pivot Table let me know, that would be easy to do. Alternatively, you can use a SUMIFS function.

 

[15minoffame]

What do you mean by "group"? For each date in column A that is Jan, add all of the numbers in the individual columns? Even the percentages?

If the Dates in column A are actual dates, you can easily use a Pivot Table to group by month. It that is what you want to do and you don't know how to use a Pivot Table let me know, that would be easy to do. Alternatively, you can use a SUMIFS function.

I'm sorry, I should've explained it better. I tried the Pivot Table, but it didn't work so obviously, I'm not doing something right. This is what I'm looking for when I mean by grouping. In this example, I want to group all January together and its corresponding percentages. Then I want to do the same for April, July & October. Please disregard the boxes within this grid, not sure why they're there.

DATE	Pct	1 DAY	3 DAYS	5 DAYS	8 DAYS	13 DAYS	21 DAYS
Fri 01/22/2016 BO <tbody> </tbody>	-0.13% <tbody> </tbody>	-1.22%	-1.22%	-0.97%	1.78%	0.27%	-3.98%
Fri 01/23/2015 BO	0.61% <tbody> </tbody>	0.82%	0.82%	0.41%	-1.60%	-0.49%	2.51%
Fri 01/17/2014 BO	-1.17% <tbody> </tbody>	-2.27%	-2.27%	-3.34%	-8.27%	-7.02%	-8.27%
Fri 01/18/2013 BO	3.00% <tbody> </tbody>	3.47%	3.45%	3.31%	4.63%	4.35%	5.53%
Fri 04/17/2015 BO	0.43% <tbody> </tbody>	-0.10%	-0.10%	-2.41%	-1.75%	-0.69%	-0.87%
Thu 04/17/2014 BO	1.33% <tbody> </tbody>	1.68%	1.68%	1.79%	1.30%	2.45%	1.56%
Fri 04/19/2013 BO	-3.22% <tbody> </tbody>	-4.05%	-4.05%	-5.16%	-2.02%	-2.29%	0.48%
Fri 04/20/2012 AC	-1.54%	-1.49%	-1.54%	0.42%	2.13%	1.28%	-1.81%
Fri 07/17/2015 BO	0.81% <tbody> </tbody>	0.73%	0.73%	-0.70%	-4.77%	-2.88%	-3.73%
Fri 07/18/2014 BO	0.60% <tbody> </tbody>	-0.56%	-0.56%	-2.21%	-3.08%	-3.64%	-4.17%
Fri 07/19/2013 BO	2.45% <tbody> </tbody>	4.61%	4.61%	4.57%	4.31%	3.13%	2.96%
Fri 07/20/2012 BO	0.45% <tbody> </tbody>	0.35%	0.36%	0.88%	5.69%	4.71%	6.36%
Fri 10/16/2015 BO	2.06% <tbody> </tbody>	3.38%	3.38%	2.67%	5.28%	4.85%	5.74%
Fri 10/17/2014 BO	3.09% <tbody> </tbody>	2.35%	2.35%	4.94%	5.73%	5.81%	8.70%
Fri 10/18/2013 BO	2.14% <tbody> </tbody>	3.52%	3.52%	5.42%	4.86%	6.84%	7.77%
Fri 10/19/2012 BO	-1.31% <tbody> </tbody>	-3.41%	-3.43%	-6.69%	-7.44%	-7.67%	-8.42%

<colgroup><col><col span="7"></colgroup><tbody>
</tbody>

 

[15minoffame]

Uggh. why does the IMG file thing keeps showing up? Sorry about that.

 

[Joyner]

So do you just want to sort the dates so they are together by month? I assume you have tried to sort, but that doesn't work? If it doesn't work then the "Dates" in column A must be Text and not actual dates. If that is the case, I think you will need to use a helper column. I would insert a new column A with a heading of "Month" and use this formula to sort on (where your "Date" column is now in column B):

=MID(TRIM(B1),5,2)

Then you can sort on the new column A;

If you what an actual date to sort on so the data is in date order, try this formula instead in column A (format the range to Short Date):

=DATEVALUE(MID(TRIM(C1),5,10))

Now you can put the date in actual date sequence and all months will be together. If I missed what you need, let me know.