software

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 quot;Repeatedquot; if any vessel name repeats in col B. Example-
Parties NameVessel Name Remarks

Anis quot;Marissaquot; -
Nazmul quot;Maerskquot; “Repeated”
Sujon quot;Banga Bijoyquot; -
Nazmul quot;Maerskquot; “Repeated”
Ashfak quot;BBN quot; -

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 - www.officehelp.inEnter in C1:
=IF(COUNTIF(B1:B99,B1)gt;1,quot;Repeatedquot;,quot;quot;)
then drag down

Cheers,
--
AP

quot;rony4icabquot; gt; a écrit dans le message de
news: ...
gt;
gt; Help on function needed!!!
gt; I made a sheet in which in col A there are parties name and in column B
gt; there are Vessels name, now in coloumn C named Remarks I want to give a
gt; comment of quot;Repeatedquot; if any vessel name repeats in col B. Example-
gt; Parties Name Vessel Name Remarks
gt;
gt; Anis quot;Marissaquot; -
gt; Nazmul quot;Maerskquot; quot;Repeatedquot;
gt; Sujon quot;Banga Bijoyquot; -
gt; Nazmul quot;Maerskquot; quot;Repeatedquot;
gt; Ashfak quot;BBN quot; -
gt;
gt; Please help me in this regard. one thing more this is my first request
gt; to officehelp.
gt; And thanks in advance to all.
gt;
gt; Nazmul (rony4icab)
gt; E-mail :
gt; Call/Give Message: 880171653446
gt; Bangladesh.
gt;
gt;
gt; --
gt; rony4icab
gt; Posted from - www.officehelp.in
gt;
Hi,
Maybe you can use something like this in cell C1:

=IF(COUNTIF($B$1:$B$100,B1)gt;1,quot;Repeatedquot;,quot;-quot;)

And then copy down your list.

Regards,
Bondi
Hello!
Thanks a lot to Ardus Pitus amp; Bondi for the function. Wish you best
regards from myself.
Good Luck.
Nazmul (rony4icab)
E-mail :
Call/Give Message: 880171653446
Bangladesh.--
rony4icab
Posted from - www.officehelp.in