Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
DataValidation Check in cell of excel
there are 3 excel cols,
when user enters in col1, it should be allowed only if data is not present in col2 and col3. also when enters in col2, not be allowed to enter if data is there in col1 and col3 also when enters in col3, not be allowed to enter is data is there in col1 and col2 so which is the formula to use in the excel col so that the above holds true. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Offset Named range in Datavalidation List | Excel Discussion (Misc queries) | |||
Count entries in a range that match a certain criteria within datavalidation. | Excel Discussion (Misc queries) | |||
datavalidation conditional list | Excel Discussion (Misc queries) | |||
datavalidation conditional list | Excel Discussion (Misc queries) | |||
Datavalidation using lists - problem in 2007 B2TR to RTM workbook | Excel Discussion (Misc queries) |