Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to write a dependent validation with all numbers
need to place a value in A1 and have an associated drop down menu auto placed in A2?
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how to write a dependent validation with all numbers
need to place a value in A1 and have an associated drop down menu auto
placed in A2? Here's one way. Put the values for the drop-down lists in consectuive columns someplace; for example, H1:H7 for A1=1 I1:I10 for A1=2 etc. Then use Data Data tools Data Validation Data Validation and in the dialog box choose Allow: List Source: =OFFSET(G1,0,A1,COUNTA(OFFSET(G1,0,A1,10000,1),1)) and fill in the remaining DV settings as desired. If the A1 values are other constants (that is, if they aren't the counting numbers 1,2,3,...) first use MATCH(A1,...,0) with a list of the allowed A1 values to get a counting number for the Source (in place of simply A1). Hope this helps getting started. (I have Excel 2010.) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dependent Validation | Excel Worksheet Functions | |||
Dependent Validation | Excel Worksheet Functions | |||
Dependent Validation | Excel Worksheet Functions | |||
Dependent Validation List | Excel Programming | |||
Validation of cells who is dependent on each other | Excel Discussion (Misc queries) |