how do I nest a drop down cell within a conditional statement?
 

I have 4 columns in a spreadsheet that are formatted for drop down options.
I am interested in restricting the selection of options previously selected
so as to eliminate double entries.

How do I do this? Any suggestions will be greatly appreciated

how do I nest a drop down cell within a conditional statement?
 

See this:

http://contextures.com/xlDataVal03.html

--
Biff
Microsoft Excel MVP


"Neal" wrote in message
...
I have 4 columns in a spreadsheet that are formatted for drop down options.
I am interested in restricting the selection of options previously
selected
so as to eliminate double entries.

How do I do this? Any suggestions will be greatly appreciated