Formula for duplicate entries?

J

JENNYC

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

Column A has check boxes (from the "forms" 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 las
name is entered so we are aware of it

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

thanks much
 
B

Bob Phillips

=COUNTIF(B:B,B1)>1

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
Top