Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pick from lists
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Pick from lists
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pick from lists | Excel Discussion (Misc queries) | |||
Help with Lists... | Excel Discussion (Misc queries) | |||
Pick Lists Problem | Setting up and Configuration of Excel | |||
How do I use an IF statement to pick between two lists? | Excel Discussion (Misc queries) | |||
Using Pick Lists | Excel Worksheet Functions |