Hi all,
Here's what I'm having trouble with:
I have a spreadsheet with 5 columns, risk levels 1-5. On a separate tab, I want to have a dropdown for each of the 5, but have it list all corresponding values without the duplicates.
For example, in the attached file you will see....Level 1 Risk, I only want Lawfulness listed once, and the second one should have Corporate Governance (listed once), Legal (listed once), level 3 Communication & Reporting Listed once.
Basically I need each dropdown to be uniquely listed depending on the value of the dropdown before it and not have duplicates.
Is this even possible?? Thanks for any help you can provide!!!
Bookmarks