I have been using data validation in excel for some worksheets where I use the columns as inputs for a formula at the end of the row.
But I was not aware that it is not case sensitive, i.e. all the entries in the second worksheet like WAN do not take effect. A user can type wan and then continue.
To achieve case sensitivity you have to actually put all possible entries into the dialog of the data-validation->source as a comma separated list.
Source WAN,LAN,CAN,MAN...
A very good resource is also http://www.contextures.com/xldataval01.html
No comments:
Post a Comment