EXCEL Count Dublicate Text

[RZ100]

Hi guys,
I would like to ask how can I count dublicate text and shows me into another cell - the name and number of duplicates:



Numbers Market Number of dublicates Dublicates NAME
1 Market 1 2 Market 6
1 Market 2
0 Market 3
1 Market 4
0 Market 6
1 Market 6

Many thanks!

 

[PaddyD]

would a pivot table suffice?

market in the row area, count of market in the data area?

 

[Ali Kırksekiz]

Originally Posted by RZ100
Hey Ali , i have last question
I try to change cell range,but have some problem.
I want to be - 300
I Change all formulas

but In this formula have problem.

{=IF(ROWS($F$2:F2)<=$I$1,INDEX($B$2:$B$15,SMALL(IF($C$2:$C$15=1,ROW($C$2:$C$15)-ROW($C$2)+1),ROWS($F$2:F2))),"")}

I change all - (15 with 300 )

But is not work .
Work only with old range...

See ..
http://www.flickr.com/photos/77956853@N07/6838461808/

Could you control $I$1 cells. $I$1 value must be 7

 

[RZ100]

O yeee baby .. its work )

Many Thanks !
Is there any point in the forum to vote for you for helping or something