https://community.hpe.com/t5/operating-system-microsoft/question-in-msexcel/m-p/3474355#M5784 hi all<BR /><BR />i want to prevent user to insert a duplicate value in column "B" in worksheet.<BR /><BR />how can i do that<BR /><BR />thankx Sun, 30 Jan 2005 10:27:13 GMT kamal_15 2005-01-30T10:27:13Z https://community.hpe.com/t5/operating-system-microsoft/question-in-msexcel/m-p/3474355#M5784 hi all<BR /><BR />i want to prevent user to insert a duplicate value in column "B" in worksheet.<BR /><BR />how can i do that<BR /><BR />thankx Sun, 30 Jan 2005 10:27:13 GMT https://community.hpe.com/t5/operating-system-microsoft/question-in-msexcel/m-p/3474355#M5784 kamal_15 2005-01-30T10:27:13Z https://community.hpe.com/t5/operating-system-microsoft/question-in-msexcel/m-p/3474356#M5785 Kamal,<BR /><BR />I think you'll need to use the Data Validation feature. Refer here in line 57:<BR /><A href="http://www.exceluser.com/help/formula/long002.htm" target="_blank">http://www.exceluser.com/help/formula/long002.htm</A><BR /><BR />Hope this help<BR /> Sun, 30 Jan 2005 13:24:42 GMT https://community.hpe.com/t5/operating-system-microsoft/question-in-msexcel/m-p/3474356#M5785 Norman_21 2005-01-30T13:24:42Z