Take a look at Debra Dalgleish's page at:
http://www.contextures.com/xlDataVal13.html
Data Validation -Dependent Dropdowns from a Sorted List
--
Rgds
Max
xl 97
---
Singapore, GMT+8
xdemechanik
http://savefile.com/projects/236895
--
"Tony" wrote in message
...
Want to set a drop down box that does not repeat the same value despite
that
value appearing in the list more than once.

Then once a selection is made from the 1st drop down list, the second drop
down box selection criteria changes.

ie. table a follows:
list 1 list2
commodities oil
commodities plastics
FX options
FX spot
FX longcall

1st list would have 2 options: commodities, FX - not repeated. User
selects
"commodities".

Then 2nd drop down list automatically changes to contain only: oil,
plastics
- as commodities was chosen in the 1st list.

Hope there is a way to do this, without setting up separate lists for each
possible combination?
Thanks, Tony