Data validation

  • Thread starter Thread starter ian c
  • Start date Start date
I

ian c

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.
 
**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.
 
Back
Top