| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
validate duplicate entry in a column
would like error notification when a duplicate entry is made in a specific
column in excel worksheet can this be done with validation function ? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
validate duplicate entry in a column
This works if you have entries in column A and check column B against it ( it will tell you in which row your duplicates are. Put this in column C and fill down. =IF(ISNA(MATCH(B1,A$1:A$8000,0)),"no match","ID is in Row: " & MATCH(B1,A$1:A$8000,0)) "wangan" wrote: would like error notification when a duplicate entry is made in a specific column in excel worksheet can this be done with validation function ? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
validate duplicate entry in a column
See:
http://www.cpearson.com/excel/NoDupEntry.htm -- Gary''s Student - gsnu200724 "wangan" wrote: would like error notification when a duplicate entry is made in a specific column in excel worksheet can this be done with validation function ? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
validate duplicate entry in a column
the foumlua works.
but if i using cncatenate, it cant. any tips to further enchance? "ufo_pilot" wrote: This works if you have entries in column A and check column B against it ( it will tell you in which row your duplicates are. Put this in column C and fill down. =IF(ISNA(MATCH(B1,A$1:A$8000,0)),"no match","ID is in Row: " & MATCH(B1,A$1:A$8000,0)) "wangan" wrote: would like error notification when a duplicate entry is made in a specific column in excel worksheet can this be done with validation function ? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
validate duplicate entry in a column
i had seen that website long before.
it cant works if i using CONCATENATE formula in that column. "Gary''s Student" wrote: See: http://www.cpearson.com/excel/NoDupEntry.htm -- Gary''s Student - gsnu200724 "wangan" wrote: would like error notification when a duplicate entry is made in a specific column in excel worksheet can this be done with validation function ? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| converted a column to List yet wants to Validate as well | Excel Discussion (Misc queries) | |||
| Highlight Duplicate on entry | Setting up and Configuration of Excel | |||
| Validate in WS to prevent dual data entry | Excel Worksheet Functions | |||
| Validate MsgBox Entry to Data in Cells | Excel Discussion (Misc queries) | |||
| Assign a Value to a Duplicate Entry Within the Same Column | Excel Discussion (Misc queries) | |||
Linear Mode
