Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
search column for duplicate value during data entry
I'm entering data one row at a time. When I enter a value in column A, I need
to know if that value has been entered (in Column A) before. Column A needs to be unique values. What is the best way to verify uniqueness, as I enter a new value? Should I use a module or can a formula check for? I'd prefer to have a Warning box pop up indicating "Value already entered in this column", so I'm assuming a module (VB?) is the way to go. If you have any suggestions, I'd be happy to read. Thanks, |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
search column for duplicate value during data entry
The easiest way to do this is to use a conditional format. Take a look and
see if that helps. -- HTH, Barb Reinhardt "smpk42" wrote: I'm entering data one row at a time. When I enter a value in column A, I need to know if that value has been entered (in Column A) before. Column A needs to be unique values. What is the best way to verify uniqueness, as I enter a new value? Should I use a module or can a formula check for? I'd prefer to have a Warning box pop up indicating "Value already entered in this column", so I'm assuming a module (VB?) is the way to go. If you have any suggestions, I'd be happy to read. Thanks, |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
search column for duplicate value during data entry
Sweet.
That does the trick - if a dup number is entered, it appears in Red. I figured it could be done simply. Thanks Barb. "Barb Reinhardt" wrote: The easiest way to do this is to use a conditional format. Take a look and see if that helps. -- HTH, Barb Reinhardt "smpk42" wrote: I'm entering data one row at a time. When I enter a value in column A, I need to know if that value has been entered (in Column A) before. Column A needs to be unique values. What is the best way to verify uniqueness, as I enter a new value? Should I use a module or can a formula check for? I'd prefer to have a Warning box pop up indicating "Value already entered in this column", so I'm assuming a module (VB?) is the way to go. If you have any suggestions, I'd be happy to read. Thanks, |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
search column for duplicate value during data entry
See Chip Pearson's site for using Data Validation to prevent duplicate
entries in a column. http://www.cpearson.com/excel/NoDupEntry.aspx Gord Dibben MS Excel MVP On Wed, 31 Mar 2010 11:21:01 -0700, smpk42 wrote: I'm entering data one row at a time. When I enter a value in column A, I need to know if that value has been entered (in Column A) before. Column A needs to be unique values. What is the best way to verify uniqueness, as I enter a new value? Should I use a module or can a formula check for? I'd prefer to have a Warning box pop up indicating "Value already entered in this column", so I'm assuming a module (VB?) is the way to go. If you have any suggestions, I'd be happy to read. Thanks, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search for duplicate entries in a column of numbers | Excel Worksheet Functions | |||
validate duplicate entry in a column | Excel Discussion (Misc queries) | |||
APPROXIMATE SEARCH OF ANY ENTRY IN A COLUMN | Excel Worksheet Functions | |||
Assign a Value to a Duplicate Entry Within the Same Column | Excel Discussion (Misc queries) | |||
How do I search for duplicate words in a column? | Excel Worksheet Functions |