|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 25th, 2007, 02:42 PM
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
May 25th, 2007, 02:53 PM
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
May 25th, 2007, 02:54 PM
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
June 5th, 2007, 06:46 AM
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
June 5th, 2007, 01:38 PM
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 ?
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
