Home |
Search |
Today's Posts |
#1
|
|||
|
|||
prevent duplicate entry for range of numbers 00001 to 99999 in ex.
is there a way to prevent a duplicate entry for a range of numbers between
00001 and 99999 in column? Thanks ... TK |
#2
|
|||
|
|||
Although it has its limitations, Validation is one way:
1. Select the range. 2. Go to Data Validation. 3. Under "Allow" select "Whole Number". 4. Fill in the "Min" with 0 and "Max" with 99999. HTH Jason Atlanta, GA -----Original Message----- is there a way to prevent a duplicate entry for a range of numbers between 00001 and 99999 in column? Thanks ... TK . |
#3
|
|||
|
|||
Or use this technique since I doubt it will prevent duplicates
http://www.cpearson.com/excel/NoDupEntry.htm -- Regards, Peo Sjoblom "Jason Morin" wrote in message ... Although it has its limitations, Validation is one way: 1. Select the range. 2. Go to Data Validation. 3. Under "Allow" select "Whole Number". 4. Fill in the "Min" with 0 and "Max" with 99999. HTH Jason Atlanta, GA -----Original Message----- is there a way to prevent a duplicate entry for a range of numbers between 00001 and 99999 in column? Thanks ... TK . |
#4
|
|||
|
|||
TK
Chip Pearson shows you how using Data Validation http://www.cpearson.com/excel/NoDupEntry.htm Gord Dibben Excel MVP On Fri, 4 Mar 2005 13:07:05 -0800, "TK" wrote: is there a way to prevent a duplicate entry for a range of numbers between 00001 and 99999 in column? Thanks ... TK |
#5
|
|||
|
|||
thanks for the link ... just what I needed ... TK
"Gord Dibben" wrote: TK Chip Pearson shows you how using Data Validation http://www.cpearson.com/excel/NoDupEntry.htm Gord Dibben Excel MVP On Fri, 4 Mar 2005 13:07:05 -0800, "TK" wrote: is there a way to prevent a duplicate entry for a range of numbers between 00001 and 99999 in column? Thanks ... TK |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent duplicate entries | Excel Worksheet Functions | |||
finding duplicate entry | New Users to Excel | |||
Duplicate invoice numbers | Excel Discussion (Misc queries) | |||
How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
Add numbers for duplicate entries then delete | Excel Worksheet Functions |