Count number of cells in column with same text, without pre-specifying text (? wildcard)

[Gazzat]

Hi (question below screenshot) ,

Large spreadsheet with some replicate values in column A. I am wanting to count how many replicates in column A and then establish a count of cells with each replicate value, so I can order them eg. I would like to know how many cells in column A contain C7532, how many cells in column A contain W4254.............etc- but without having to specify each value in the county formula.
I feel like I'm missing something obvious, but have been going in circles for a while so some help would be greatly appreciated
Thanks!
Gaz

 

[Jeffrey Mahoney]

Put this formula in cell D2 and copy it down to all the used rows.
Cell D2: =Countif(A:A,A2)

 

[Peter_SSs]

Is this the sort of thing you mean, using Excel's built-in Pivot Table feature (available on the 'Insert' ribbon tab)?

21 12 11.xlsm
	A	B	C	D	E
1	Header 1	Header 2		Count of Header 1
2	C7532	Data 1		Header 1	Total
3	W4254	Data 2		B9834	2
4	B9834	Data 3		C7532	5
5	C7532	Data 4		W4254	3
6	C7532	Data 5		Grand Total	10
7	W4254	Data 6
8	B9834	Data 7
9	C7532	Data 8
10	C7532	Data 9
11	W4254	Data 10
12
PT