Using Pivot

fullbacktat

New Member
Joined
Feb 19, 2005
Messages
2
I am trying to conduct a run consisting of a 1Mile, 5K, and a 10K. With age groups from >=17, 18-29, 30-39, and <=40.

I have been able to get PIVOT table to count the individual ages of the racers but not into the categories.

........B.............C
......AGE.........EVENT
2.....17...........10K
3.....28...........5K
4.....40...........1Mile
5.....35...........10K

This is an example of my raw data. How do I get it into a Pivot Table and my ages into a the right group.


I am looking to fill in these answers:

.......>=17.......18-29.....30-39...<=40....Total
1Mile..........................................1........1

5K....................1..................................1

10K.....1.........................1....................2

Total...1...........1.............1..........1........4

The above table is what I am looking to create. I am fairly new at excel so please explain at a novice level.

Thanks in advance.
 

Some videos you may like

Excel Facts

Control Word Wrap
Press Alt+Enter to move to a new row in a cell. Lets you control where the words wrap.

eliW

Well-known Member
Joined
Mar 2, 2002
Messages
1,931
If your intervals are even, you can use "Group and outline" from pivot table menu.

Eli
 

Mark W.

MrExcel MVP
Joined
Feb 10, 2002
Messages
11,654
Book1
ABCDEFGH
1AGEEVENTCATEGORY
21710K<=17
3285K18-29
4401Mile>=40
53510K30-39
6
7
8CountCATEGORY
9EVENT<=1718-2930-39>=40Grand Total
101Mile11
115K11
1210K112
13Grand Total11114
14
15
Sheet1
 

fullbacktat

New Member
Joined
Feb 19, 2005
Messages
2
Thanks a lot. I had to add another colomn outside the print area but it worked like a charm. I would not have figured it by Tuesday on my own.


Again Thanks a lot, now I hope my boss doesn't think I a wiz at excel :eek:
 

Watch MrExcel Video

Forum statistics

Threads
1,123,474
Messages
5,601,880
Members
414,479
Latest member
Beau the dog

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top