cancel
Showing results for 
Search instead for 
Did you mean: 

question in MSEXCEL

kamal_15
Regular Advisor

question in MSEXCEL

hi all

i want to prevent user to insert a duplicate value in column "B" in worksheet.

how can i do that

thankx
1 REPLY
Norman_21
Honored Contributor

Re: question in MSEXCEL

Kamal,

I think you'll need to use the Data Validation feature. Refer here in line 57:
http://www.exceluser.com/help/formula/long002.htm

Hope this help
"Attitudes are contagious, is yours worth catching"/ My first point was given by SEP on January 31, 2003