Forum Discussion
Data Validation multiple
I have sheet that has a drop-down to select "Annual" or "Semi-annual". The following row contains a data validation drop-down to select the month for "Annual", and the row below that contains the sam...
Riny_van_Eekelen Thanks for the suggestion, but the problem is that the cell contains a drop down DV list. It will let me do one or the other, but not both.
Mariegb Then you can perhaps use a solution like in the attached file. The DV rule for the 2nd month refers to a list that starts in E2 (=$E$2#). In turn, E2 contains a formula that creates an empty list if C1 contains "Semi-annual" or a full list of months if C1 contains "Semi.annual".
Alternatively, if the 2nd month is always 6 months after the first in a semi-annual cycle, you could consider to use a calculation that adds 6 months to the first month if the frequency equals "Semi-annual". Just an idea. Have given an example of that as well in the attached workbook.