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 |
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 |
All times are GMT +1. The time now is 03:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com