Is there anybody who can hlp in the function making!!!

R

rony4icab

Help on function needed!!!
I made a sheet in which in col A there are parties name and in column
there are Vessels name, now in coloumn C named Remarks I want to give
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 reques
to officehelp.
And thanks in advance to all.

Nazmul (rony4icab)
E-mail : [email protected]
Call/Give Message: 880171653446
Bangladesh
 
B

Bondi

Hi,
Maybe you can use something like this in cell C1:

=IF(COUNTIF($B$1:$B$100,B1)>1,"Repeated","-")

And then copy down your list.

Regards,
Bondi
 
R

rony4icab

Hello!
Thanks a lot to Ardus Pitus & Bondi for the function. Wish you bes
regards from myself.
Good Luck.
Nazmul (rony4icab)
E-mail : [email protected]
Call/Give Message: 880171653446
Bangladesh
 
Top