Enter in C1:
=IF(COUNTIF(B1:B99,B1)1,"Repeated","")
then drag down

Cheers,
--
AP

"rony4icab" a écrit dans le message de
news: ...

Help on function needed!!!
I made a sheet in which in col A there are parties name and in column B
there are Vessels name, now in coloumn C named Remarks I want to give a
comment of "Repeated" if any vessel name repeats in col B. Example-
Parties Name Vessel Name Remarks

Anis "Marissa" -
Nazmul "Maersk" "Repeated"
Sujon "Banga Bijoy" -
Nazmul "Maersk" "Repeated"
Ashfak "BBN " -

Please help me in this regard. one thing more this is my first request
to officehelp.
And thanks in advance to all.

Nazmul (rony4icab)
E-mail :
Call/Give Message: 880171653446
Bangladesh.


--
rony4icab
Posted from - http://www.officehelp.in