If you're creating a project with Microsoft Excel which you don't want your users to input a same value on input area, with a little trick you can prevent it. Just combine COUNTIF function with Validation Data menu.
OK, open Microsoft Excel first then block your input area cells, in my case my input area cells are A1 until A20. So I blocked cells A1:A20. Then going to Data - Validation menu. In Settings tab, choose Custom in Allow combo box then in Formula textbox type =COUNTIF($A:$A;A1)=1. Then click Error Alert and type the message box error title and its content, type your own an error message in there. Click OK button.
Now try to type two same value in your input area.
Subscribe to:
Post Comments (Atom)
0 comments
Post a Comment