Register a value when TRIPLICATE MATCH found

[hsandeep]

How to register a number 1 in the row/(s) when ‘triplicate match’ are found?
Thanks for the help in advance.
I am using Excel2007

	B	C	D
2	Peter
3	James
4	Peter
5	Jack
6	Jack
7	Peter		1
8	Jack		1
9	Jack

<tbody>
</tbody>

 

[Special-K99]

in D2
=IF(COUNT(B$2:B2)=3,1,"")
and copy down

 

[MARZIOTULLIO]

HI

D2=IF(COUNTIF($B$2:B2,B2)=3,1,"") Copy down

 

[hsandeep]

D2=IF(COUNTIF($B$2:B2,B2)=3,1,"") Copy down[/QUOTE]

Thanks MARZIOTULLIO, IT WORKS.