Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data validation
I have a table of 5 columns the cells in each column refer to a drop down
list (so there are five different lists) i want to prevent more than one of the five cells being picked if that makes sense so in any one row if you have picked from the drop down list in one cell you are prevented form doing the same in any of the other four. hope that makes sense. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Data validation
**Maybe** something like this:
Assume the drop downs are in A1:C1 As the source for A1: =IF(AND(B1="",C1=""),source,#N/A) For the source in B1: =IF(AND(A1="",C1=""),source,#N/A) For the source in C1: =IF(AND(A1="",B1=""),source,#N/A) Where "source" is the range reference or a named range. If any cells contain an entry when you set this up you may get a message that says something like: The source currently evaluates to an error.... Just answer Yes at the prompt. -- Biff Microsoft Excel MVP "ian c" wrote in message ... I have a table of 5 columns the cells in each column refer to a drop down list (so there are five different lists) i want to prevent more than one of the five cells being picked if that makes sense so in any one row if you have picked from the drop down list in one cell you are prevented form doing the same in any of the other four. hope that makes sense. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Validation Data using Validation Table cell range..... | Excel Discussion (Misc queries) | |||
Data Validation Update Validation Selection | Excel Worksheet Functions | |||
data validation invalid in dynamic validation list | Excel Discussion (Misc queries) | |||
data validation invalid in dynamic validation list | Excel Worksheet Functions | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) |