Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation - List - Data "NOT BETWEEN" - Source Possible?
Setting up electronic log sheet where serial numbers are entered. Trying to
use VALIDATION to check previous entry's for duplicates. If "Data" was able to be change to "Not Between" that would be great, but this window is greyed out in Data Validation. Is there another way? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data Validation - List - Data "NOT BETWEEN" - Source Possible?
"Duke2U" wrote:
Setting up electronic log sheet where serial numbers are entered. Trying to use VALIDATION to check previous entry's for duplicates. If "Data" was able to be change to "Not Between" that would be great, but this window is greyed out in Data Validation. Is there another way? Try this .. Select the data input range, say A2:A20 (with A2 active) Then click Data Validation Custom Formula: =AND(COUNTIF($A$2:A2,A2)<2,A2=1000,A2<=2000) Click OK The formula will disallow duplicate entries down the range, and also ensures that only numbers between 1000 to 2000 [inclusive] are permitted (as an example) Test it out and adapt to suit .. -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation - using a list from another workbook | Excel Discussion (Misc queries) | |||
Data Validation List Length | Excel Worksheet Functions | |||
Data Validation and Blanks in List | Excel Worksheet Functions | |||
Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
Using Validation List from Another Workbook with Dependent Data | Excel Worksheet Functions |