I have a 3 column table of data and I need to create drop down list based on these 3 columns.
- Column 1 has duplicate values.
- Column 2 also has duplicate values. The options are dependent on the value chosen from drop down 1.
- Column 3 is dependent on the options chosen in both columns 1 and 2, while only displaying the unique values from each column.
I have found ways to limit the options in the drop downs based on the previous selection, but can't find anything to limit the options in column 3 based on the selections from both 1 and 2.
Is this something that can be accomplished without the use of VBA? The workbook must be in an XLSX format, so it cannot contain any macros.
If a user selects John then only North and West should appear in drop down list 2.
If user selects John and West, then only South should appear in drop down list 3.