Counting the Number of identical Cells in a column.

rob737

Board Regular
Joined
May 12, 2015
Messages
129
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
 

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)
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.
 
Last edited:
Upvote 0
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.
 
Upvote 0
=if(or(a2=a3,a2=""),"",countif(a$2:a10000,a2))
 
Upvote 0

Forum statistics

Threads
1,223,248
Messages
6,171,027
Members
452,374
Latest member
keccles

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
Back
Top