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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200707/1

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



"adeel via OfficeKB.com" wrote:

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200707/1

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

"adeel via OfficeKB.com" wrote:

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.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...excel/200707/1