Counting the Number of identical Cells in a column.

[rob737]

Hi Forum.
Hope all is well.

I would like help to count the number of identical text cells in a column A. They all exist in sequence as follows:

A K
Text1
Text1
Text1 3
----------------------------------
Text2
Text2 2
--------------------------------
Text 3
Text 3
Text 3
Text 3 4

I would like to write the total count into column K

As always, any help with this would be greatly appreciated.

Many thanks
Regards
Rob

 

[Beyond_avarice]

You Can either use the Workbook Countif function.

You can pivot table the column "A" and make Column "A" the Row label and "Count" values

You could subtotal the information through Data > Outline > Subtotal.

 

[BrianJN1]

This is not exactly what you asked but it is a start.
I've worked on Columns A and K as per your example.

Put "1" in K1 add this formula in K2, =IF(A2=A1,K1+1,1) and then drag it down.
I'm sure that someone may find a creative way to eliminate the lower the values for each case.

 

[footoo]

=if(or(a2=a3,a2=""),"",countif(a$2:a10000,a2))

 

[rob737]

Great many thanks everyone just what I was after

Regards ROb