Forum Discussion
Solved
Can anyone make this dependent?
I have a list of unique values I need to make dependent, can anyone help?
I ran into an issue though, I only have excel 2016 so this formula doesn’t work for me 😞 any chance you know another solution?
novakdz Oh.... I thought you had access to Excel on Office365. Consider an upgrade, perhaps? For a relatively small fee per month you get the newest of the newest.
I recall that the video you found referred to "the old way of doing it". It took her 34 minutes to explain. Not sure I can do it any quicker. Can try to build something, but someone else out here might already have done it. Otherwise, invest some time in making the Named Ranges I talked about earlier. Relatively easy to make and maintain. Though not very "sexy".
- Okay and you don’t have to build anything else, thank you for your help. The named ranges go too confusing I will just try to upgrade.