EXCEL Count Dublicate Text - How?

What I would do is create a macro to do this.
1. The first thing is to copy the original list to a temporary location.
2. Next, I would remove the duplicates from the copied list.
3. Then I would scan the non-duplicate list and the duplicate list and get the occurance counts and place these counts next to the non-duplicate list(like in your example).

If you want to avoid macros, it gets a little tricky to output results in the format you desire.

Attached is a spreadsheet that gets your desired functionality, but can only display the duplicate results ("Number of duplicates" and "DuplicatesNAME") next to the actual Market # that has duplicates. If you only want to display these results starting from the top, you either need to use a macro or you need to put a formula in each cell such that the formula checks every cell in a given column (ex. If this row's value isn't a duplicate, look at the next row in the column and see if that has a duplicate, and if that doesn't have a duplicate, go to the next row, and so on.)

Let me know if you need help understanding the logic in this spreadsheet.

The "Dup?" value returns TRUE if the next row's market # is equal to the current row's market # (i.e. at least one duplicate has been found).

The "Count" value actually finds the number of occurrences of the current market #, but ignores any instances where the previous "Dup?" is TRUE since that means the current market # is equal to the previous market # and we only need to count duplicates for a given market # once.

Just hide those 2 middle columns when displaying the results.

Hello Guys ,
Thanks a Lot !
You are the best !

You can do that without helping columns as:

=IF(COUNTIF(B$3:B3,B3)>1,B3,"")

or if you get error:

=IF(COUNTIF(B$3:B3;B3)>1;B3;"")