Put this in B2 and drag down

=IF(COUNTIF($A$2:$A$20,A2)1,"Yes","No")

Mike

"Arun" wrote:

i am entering names+a 4 digit no (eg Arun1254) in one colum
can u help me to find the text is reapeted comming rows
my datas are not sorted ..

Col A Col B

Name+ no yes/no
Arun no
vass no
arun yes
raj no
arun yes

which functinn would hepl to come yes/no in Col B