software

Hi! i am in need of the formula(s) i would use to make the following
worksheet happen, hope one of y'all can help me!...i think this is an
easy one!!??

Column A has check boxes (from the quot;formsquot; toolbar)
Column B has last names....anywhere from hundreds to thousands of them

duplicates are ok, i just want the box checked when a duplicate last
name is entered so we are aware of it

I am setting up the worksheet to automatically check the box in column
A if there is a duplicate name in B1:b1000. I know how to set the
checkbox to link to the formula to make that happen....just don't know
what that formula/formulas should be!!?? Does anyone follow me amp; know
what i should use!!??

thanks much!--
JENNYC
------------------------------------------------------------------------
JENNYC's Profile: www.excelforum.com/member.php...oamp;userid=19579
View this thread: www.excelforum.com/showthread...hreadid=510208=COUNTIF(B:B,B1)gt;1

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

quot;JENNYCquot; gt; wrote in
message ...
gt;
gt; Hi! i am in need of the formula(s) i would use to make the following
gt; worksheet happen, hope one of y'all can help me!...i think this is an
gt; easy one!!??
gt;
gt; Column A has check boxes (from the quot;formsquot; toolbar)
gt; Column B has last names....anywhere from hundreds to thousands of them
gt;
gt; duplicates are ok, i just want the box checked when a duplicate last
gt; name is entered so we are aware of it
gt;
gt; I am setting up the worksheet to automatically check the box in column
gt; A if there is a duplicate name in B1:b1000. I know how to set the
gt; checkbox to link to the formula to make that happen....just don't know
gt; what that formula/formulas should be!!?? Does anyone follow me amp; know
gt; what i should use!!??
gt;
gt; thanks much!
gt;
gt;
gt; --
gt; JENNYC
gt; ------------------------------------------------------------------------
gt; JENNYC's Profile:
www.excelforum.com/member.php...oamp;userid=19579
gt; View this thread: www.excelforum.com/showthread...hreadid=510208
gt;

Thanks Bob! --
JENNYC
------------------------------------------------------------------------
JENNYC's Profile: www.excelforum.com/member.php...oamp;userid=19579
View this thread: www.excelforum.com/showthread...hreadid=510208