HPE Community
Operating System - Microsoft
1752793 Members
6478 Online
108789 Solutions
New Discussion

question in MSEXCEL

 
kamal_15
Regular Advisor

‎01-30-2005 02:27 AM

‎01-30-2005 02:27 AM

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
0 Kudos
Reply
1 REPLY 1
Norman_21
Honored Contributor

‎01-30-2005 05:24 AM

‎01-30-2005 05:24 AM

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
0 Kudos
Reply
The opinions expressed above are the personal opinions of the authors, not of Hewlett Packard Enterprise. By using this site, you accept the Terms of Use and Rules of Participation.