Forum Discussion
Data Validation multiple
Mariegb Assuming the cell with the drop-down is in C1, try the following DV rule in C3
=C1="Semi-annual"It should only allow entry of data in C3 if the value in C1 equals "Semi-annual".
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.
