Pivot table question

[tdkooch]

Hello all,
I am working on a Excel data table. The 3 columns are year(i.e.
2011), dollar amount, purchase dollar amount. I have been asked to
group by year in the following buckets.

0-2 years
2-3 years
3-5 years
5-10 years
10+ years

I seem to be able to group by 2 year intervals, 3 year intervals etc,
but cannot seem to group as I have been asked. That is 2 years, then
1 year, then 2 years, then 5 years. Any help would be greatly
appreciated. Thank you! TimD

 

[trip_to_tokyo]

Hello all,
I am working on a Excel data table.  The 3 columns are year(i.e.
2011), dollar amount, purchase dollar amount.  I have been asked to
group by year in the following buckets.

0-2 years
2-3 years
3-5 years
5-10 years
10+ years

I seem to be able to group by 2 year intervals, 3 year intervals etc,
but cannot seem to group as I have been asked.  That is 2 years, then
1 year, then 2 years, then 5 years.  Any help would be greatly
appreciated. Thank you!  TimD

Which version of EXCEL please?

 

[trip_to_tokyo]

Hello all,
I am working on a Excel data table.  The 3 columns are year(i.e.
2011), dollar amount, purchase dollar amount.  I have been asked to
group by year in the following buckets.

0-2 years
2-3 years
3-5 years
5-10 years
10+ years

I seem to be able to group by 2 year intervals, 3 year intervals etc,
but cannot seem to group as I have been asked.  That is 2 years, then
1 year, then 2 years, then 5 years.  Any help would be greatly
appreciated. Thank you!  TimD

Which version of EXCEL please?

 

[tdkooch]

Which version of EXCEL please?

Excel 2007 thank you