DUPLICATE VALUES

  • Thread starter Thread starter adeel via OfficeKB.com
  • Start date Start date
A

adeel via OfficeKB.com

On my work place I maintain record which have Sr. Codes, every time I enter
new record I enter New Sr. Code. please tell me some way that duplicate Codes
not enter. if i try to enter code which I have already enter the error
message come which prompt me for duplicate entry.
 
Try Data=>Validation

Select column (in this example it is A)

Allow: Custom

Formula is: =COUNTIF(A:A,A1)=1

Add your message in the "Error Alert" tab

HTH
 
Hi,

Select your column (in this case column A) and then

Data|validation
From the dropdown select Custom and then paste this formula in

=MATCH(A1,$A:$A,0)=ROW(A1)

Mike
 
Back
Top