| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Preventing user entering duplicate values in a cell range
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| cell address rather than range name | Excel Discussion (Misc queries) | |||
| Default Cell Values & Save Changes Dialog Box | Excel Discussion (Misc queries) | |||
| Date Range within one cell | New Users to Excel | |||
| How to count a range of values in a single cell? | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
Threaded Mode
