Counting Locations

[Ems600]

I have a list of 500 locations, there are many repeats in the data. I would like to be able to count all of the locations and the repeats so that I am able to make a pie chart.

 

[Scott R]

Use a Pivot Table and count by Location.

 

[BrianM]

One way of accomplishing this would be to create a pivottable. Highlight your list then click 'Data'...'Pivottable and Pivotchart Report'...'Next'...'Next'...'Layout'...You will then see a pop up box with a field in the upper right-hand side (Your header)...drag it to 'Row' and drag it to 'Data'...click 'Ok'... then 'Finish'. You can then create your chart from there.

Book2
	A	B	C	D
1	Locations
2	250A	Count of Locations
3	250A	Locations	Total
4	250C	250A	2
5	250C	250C	3
6	250C	251A	4
7	251A	251C	1
8	251A	350A	3
9	251A	351A	2
10	251A	Grand Total	15
11	251C
12	350A
13	350A
14	350A
15	351A
16	351A
17
Sheet1

Brian

 

[Ems600]

Thank You