ExcelBanter - Pick from lists

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pick from lists (https://www.excelbanter.com/excel-discussion-misc-queries/101262-pick-lists.html)

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=564900

There are instructions here for hiding used items in a data validation
dropdown list:

http://www.contextures.com/xlDataVal03.html

rbrickl wrote:
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

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html