| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Drop down list - how doo I make selection disapear?
I have a drop down list, with 16 names, and also 16 cells where the same drop
down list is displayed. What I want is this: When e.g. the name "Ann" is selected in one of the cells (based on the drop down list) I want "Ann" to disappear from all of the other drop down lists. This to ensure that one name can only be selected once, and to make sure that all names are selected at least once. How do I do that? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down list - how doo I make selection disapear?
http://cjoint.com/?bCk3PDbBzG Named ranges Choices =ListeDifference!$A$2:$A$5 ListAll =ListeDifference!$C$2:$C$7 ListDiff =ListeDifference!$E$2:$E$7 -Sélect E2:E8 =INDEX(ListAll,SMALL(IF(ISNA(MATCH(ListAll,Choices ,0)),MATCH (ListAll,ListAll,0),""),ROW(INDIRECT("1:"&ROWS(Lis tAll))))) Valid avec Shilt+Ctrl+Enter Lists en A2:A5: Data/Valid/List =ListDiff JB http://boisgontierjacques.free.fr/ On 26 jan, 10:37, Tore wrote: I have a drop down list, with 16 names, and also 16 cells where the same drop down list is displayed. What I want is this: When e.g. the name "Ann" is selected in one of the cells (based on the drop down list) I want "Ann" to disappear from all of the other drop down lists. This to ensure that one name can only be selected once, and to make sure that all names are selected at least once. How do I do that? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down list - how doo I make selection disapear?
Debra has just the ticket for this, try her page at:
http://www.contextures.com/xlDataVal03.html Excel -- Data Validation -- Hide Previously Used Items in Dropdown There's a sample file there to download (link is somewhere near the bottom on that page) -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Tore" wrote: I have a drop down list, with 16 names, and also 16 cells where the same drop down list is displayed. What I want is this: When e.g. the name "Ann" is selected in one of the cells (based on the drop down list) I want "Ann" to disappear from all of the other drop down lists. This to ensure that one name can only be selected once, and to make sure that all names are selected at least once. How do I do that? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down list - how doo I make selection disapear?
Thanx folks, this solved my problem.
Tore "Max" wrote: Debra has just the ticket for this, try her page at: http://www.contextures.com/xlDataVal03.html Excel -- Data Validation -- Hide Previously Used Items in Dropdown There's a sample file there to download (link is somewhere near the bottom on that page) -- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Tore" wrote: I have a drop down list, with 16 names, and also 16 cells where the same drop down list is displayed. What I want is this: When e.g. the name "Ann" is selected in one of the cells (based on the drop down list) I want "Ann" to disappear from all of the other drop down lists. This to ensure that one name can only be selected once, and to make sure that all names are selected at least once. How do I do that? |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Drop down list - how doo I make selection disapear?
Welcome, Tore
-- Max Singapore http://savefile.com/projects/236895 Downloads:22,500 Files:370 Subscribers:66 xdemechanik --- "Tore" wrote in message ... Thanx folks, this solved my problem. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding another selection to a drop down list | Excel Discussion (Misc queries) | |||
| Drop down list quicker selection | New Users to Excel | |||
| Can I set up a multiple selection drop down list? | New Users to Excel | |||
| Selection of Drop down list that allows you to go to a particular cell | Excel Worksheet Functions | |||
| quick selection drop down list | Excel Worksheet Functions | |||
Hybrid Mode
