Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
listbox B conditional of input in Listbox A
How do I set up listbox b choices to be a result of inpout from A? I have 9
school districts to list which will be the choice in A, Listbox B will be the choice of only the schools in the district selected in A. I assume that it is an IF stattement and a range set up but can someone help me to set this up? -- Thanks,, Kim |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
listbox B conditional of input in Listbox A
http://cjoint.com/?kFvtSwDs5J
1er list: =Choix1 2e list: =OFFSET(Choix2;1;MACTH(A1;Choix1;0)-1;COUNTA(OFFSET(Choix2;;MATCH(A1;Choix1;0)-1))-1) District1 District2 District3 District4 Scoll11 Scoll21 Scoll31 Scoll41 Scoll12 Scoll22 Scoll32 Scoll42 Scoll23 Scoll33 JB Kim K a écrit : How do I set up listbox b choices to be a result of inpout from A? I have 9 school districts to list which will be the choice in A, Listbox B will be the choice of only the schools in the district selected in A. I assume that it is an IF stattement and a range set up but can someone help me to set this up? -- Thanks,, Kim |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Date Input... | Excel Discussion (Misc queries) | |||
input box | Excel Discussion (Misc queries) | |||
VLOOKUP & Conditional Formating Help. | Excel Discussion (Misc queries) | |||
can you input time (hh:mm:ss) without having to input the colon i. | Excel Discussion (Misc queries) | |||
Conditional formatting not available in Excel | Excel Discussion (Misc queries) |