Hi All,

I wanted to create a histogram of the number of Birch trees by age
using the data below.

Height Age Type
4 2 Maple
4 2 Birch
1 3 Spruce
9 5 Spruce
5 1 Birch
1 3 Maple
10 3 Walnut
3 2 Spruce
7 4 Birch
1 2 Walnut
5 4 Pine
9 3 Walnut
2 5 Pine
2 3 Spruce
5 1 Maple
6 4 Pine
1 5 Birch
8 5 Walnut
10 5 Birch
9 3 Maple
3 1 Pine
9 4 Maple
4 3 Birch
8 1 Walnut
8 4 Maple
1 1 Maple
8 4 Birch
9 4 Maple
5 2 Pine
10 1 Maple

Is there a better way to group data together, like shown below, other
then using Data Filter?

Height Age Type
4 2 Birch
5 1 Birch
7 4 Birch
1 5 Birch
10 5 Birch
4 3 Birch
8 4 Birch

Steve


--
steve65
------------------------------------------------------------------------
steve65's Profile: http://www.excelforum.com/member.php...o&userid=37510
View this thread: http://www.excelforum.com/showthread...hreadid=571618