Hi
Take a look at Debra Dalgleish's site for information on how to do this.
http://www.contextures.com/xlDataVal01.html
Try downloading a working example from
http://www.contextures.com/DataValDealer.zip

--
Regards

Roger Govier


"rbrickl" wrote
in message ...

How do I make a pick from list but when a certain thing is already
picked then you cant pick it again below is an example

Candy / Ice Cream /
Prfference / Ranking
starburt / cotton candy /
nerds / mint/
snickers / rocky road/

Prefference box shows a choice between the type of candy or ice cream
in that row and then ranking allows a choice of ranks of all the
preferences from 1-3 without any repeats.


Thanks in advanced


--
rbrickl
------------------------------------------------------------------------
rbrickl's Profile:
http://www.excelforum.com/member.php...o&userid=35910
View this thread:
http://www.excelforum.com/showthread...hreadid=564893