Hi,
I want to create two dependent lists without duplication.
The solution should be dynamic, without VBA and, if possible, without adding columns (I already have a lot of data in this DB).
In the DATUM column, I have months that repeat as many times as file managers have worked.
For example, in the month of 01/2021 there were 3 FMs, in 02/2021 there were 4 FMs, in 03/2021 there were 2 FMs and in 04/2021 there were 5 FMs.
The aim is, in DATUM_LIST, to choose one of the 4 months (without duplicates) and then to be able to choose the FILE_MANAGER in the FILE_MANAGER_LIST which would be adapted according to the chosen month.
The aim is also to have a dynamic solution as I add new data every month.
Thank you very much for your ideas and proposals for a solution.
BR,
Lionel
For which version(s) of Excel?
Hi Velouria,
- My version : Microsoft Excel 2016 MSO (16.0.8201.2193) 32 bits.
- + Subscription: Microsoft Office 365 ProPlus
So I guess you don't have functions like FILTER or UNIQUE available?
Indeed, these functions are not available.
Hi Lionel,
If you have a 365 subscription then you should have FILTER and UNIQUE. I'm not sure why you're still using Excel 2016. I would uninstall 2016 and reinstall using your 365 license. Then you will have FILTER and UNIQUE and the task you have will be MUCH simpler.
Mynda
Hi Mynda,
This is my problem. I am part of a company that has a strategy of... blocking updates. So I find myself with an Excel that is getting old...
Lionel
It seems like a waste of money for them to pay for 365 but not use it. Anyhow, I don't envy your situation.
You can try this dependent data validation list technique which uses PivotTables.
Mynda
I sympathise as I'm in exactly the same situation at work!
