Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for duplicate entries?
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 "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 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 & know what i should use!!?? thanks much! -- JENNYC ------------------------------------------------------------------------ JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579 View this thread: http://www.excelforum.com/showthread...hreadid=510208 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for duplicate entries?
=COUNTIF(B:B,B1)1
-- HTH Bob Phillips (remove nothere from the email address if mailing direct) "JENNYC" wrote in message ... 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 "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 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 & know what i should use!!?? thanks much! -- JENNYC ------------------------------------------------------------------------ JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579 View this thread: http://www.excelforum.com/showthread...hreadid=510208 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for duplicate entries?
Thanks Bob! :) -- JENNYC ------------------------------------------------------------------------ JENNYC's Profile: http://www.excelforum.com/member.php...o&userid=19579 View this thread: http://www.excelforum.com/showthread...hreadid=510208 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
Match then lookup | Excel Worksheet Functions | |||
adding row to forumla | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
What is the formula to sum the last ten entries in a row in an Ex. | Excel Worksheet Functions |