Forums
New posts
Search forums
Members
Current visitors
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Search forums
Menu
Log in
Register
Install the app
Install
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Preventing user entering duplicate values in a cell range
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Reply to thread
Message
[QUOTE="vezerid, post: 3602014"] I suggest data validation. Use the Custom mode for column B and onwards. Enter the formula: =AND(OR(B2=1,B2=0), COUNTIF($A2:A2,1)=0) You can select all cells from B2 until G_whatever to enter this at once. You can also provide messages. For column A:A just use the simpler formula =OR(A2=1, A2=0) HTH Kostis Vezerides [/QUOTE]
Verification
Post reply
Forums
Archive
Newsgroup Archive
Excel Newsgroups
Excel Worksheets
Preventing user entering duplicate values in a cell range
Top
