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