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, |
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 |