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

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

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

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


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