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
Peter
James
Peter
Jack
Jack
Peter
Jack		1
Jack

<tbody>
[TD="bgcolor: #cacaca, align: center"]2[/TD]

[TD="bgcolor: #cacaca, align: center"]3[/TD]

[TD="bgcolor: #cacaca, align: center"]4[/TD]

[TD="bgcolor: #cacaca, align: center"]5[/TD]

[TD="bgcolor: #cacaca, align: center"]6[/TD]

[TD="bgcolor: #cacaca, align: center"]7[/TD]

[TD="align: right"]1[/TD]

[TD="bgcolor: #cacaca, align: center"]8[/TD]

[TD="bgcolor: #cacaca, align: center"]9[/TD]

</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.