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