Pivot Table Question

  • Thread starter Thread starter tdkooch
  • Start date Start date
T

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
 
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
Click to expand...

Your groups are overlapping.

Should your years not be:-

0-2 years inclusive
3-4 years inclusive
5-10 years inclusive
11 years and over.

Which version of EXCEL?

A Pivot Table would give you what you want provided you set up your
underlying data correctly (in the right buckets).
 
Your groups are overlapping.

Should your years not be:-

0-2 years inclusive
3-4 years inclusive
5-10 years inclusive
11 years and over.

Which version of EXCEL?

A Pivot Table would give you what you want provided you set up your
underlying data correctly (in the right buckets).
Click to expand...

Hi Excel 2007. You are correct about the years not overlapping. Your
buckets are correct. Thank you! I have been trying to set up the data
correctly. The data is years 2011 through 2025. Any help would be
appreciated. Again thank you.
 
Back
Top