Re: Preventing user entering duplicate values in a cell range

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: "vezerid" <vezerid@xxxxxxx>
Date: 30 Nov 2005 12:00:06 -0800

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

.

Prev by Date: Re: multiple regression template
Next by Date: Re: How do I calculate time durations over numerous dates
Previous by thread: Re: multiple regression template
Next by thread: Re: BETTER SPACING - If Then Date Range
Index(es):
- Date
- Thread

Relevant Pages

Re: Help! Stop Users from corrupting Drop Down Box Macro
... and I'm using Data Validation Drop Downs - settings: ... Use Data Validation lists in the appropriate cells - ... If Target.Cells.Count> 1 Then GoTo exitHandler ...
(microsoft.public.excel.programming)
2007 data validation not working
... I have a worksheet that includes a /lot/ of data validation cells. ... trigger the error alert or prevent the entry. ...
(microsoft.public.excel.misc)
RE: 2007 data validation not working
... I have a worksheet that includes a /lot/ of data validation cells. ... trigger the error alert or prevent the entry. ...
(microsoft.public.excel.misc)
Re: Data Validation
... If the source list is a named range that contains blank cells, ... Select the cell that contains a data validation list ... it will block invalid entries with Ignore blank on or off. ... I don't know why your users are allowed to enter a EUR unless you ...
(microsoft.public.excel)
Re: Data Validation
... Select the cell that contains a data validation list ... If the source list contains blank cells, and is a range address, ... it will block invalid entries with Ignore blank on or off. ... I don't know why your users are allowed to enter a EUR unless ...
(microsoft.public.excel)