Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
case sensitivity check for List values
hi,
i have a list of values something like this.. "Priority"----this is the header. Blocking High Medium Low i have deifned a name for this list. A column of cells can contain only these values, user have been provided dropdown for selecting from this list. but the problem is...if a user types "blocking" instead of selecting "Blocking" from the dropdown, the cell takes a value as "blocking" and never prompt it as an error. I have written a perl script that reads these values and puts them in the database. the database integrity goes for a toss if this value is put in it. Is there a way or a macro(that can be written)to provide a check for case sensitivity...? I also have other lists that dont fit the PROPER, UPPER OR LOWER case the list can be a mixture of all these.. to make matters worse i am new to using excel and have very faint idea about writing excel macros.. Please HELP... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
case sensitivity check for List values
You could try a formula in the DV like so
=EXACT(L1,INDEX(O:O,MATCH(L1,O:O,0))) where L1 is the DV cell, O is where the list is held. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) wrote in message ups.com... hi, i have a list of values something like this.. "Priority"----this is the header. Blocking High Medium Low i have deifned a name for this list. A column of cells can contain only these values, user have been provided dropdown for selecting from this list. but the problem is...if a user types "blocking" instead of selecting "Blocking" from the dropdown, the cell takes a value as "blocking" and never prompt it as an error. I have written a perl script that reads these values and puts them in the database. the database integrity goes for a toss if this value is put in it. Is there a way or a macro(that can be written)to provide a check for case sensitivity...? I also have other lists that dont fit the PROPER, UPPER OR LOWER case the list can be a mixture of all these.. to make matters worse i am new to using excel and have very faint idea about writing excel macros.. Please HELP... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Case sensitivity of functions in Excel | Excel Worksheet Functions | |||
Differentiating Case Sensitivity in a Vlookup | Excel Discussion (Misc queries) | |||
Case Sensitivity in Lookup Functions | Excel Worksheet Functions | |||
VLookup & Case Sensitivity | Excel Worksheet Functions |