Log In
Register
Home
September 9, 2020
Offline
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
Trusted Members
Moderators
November 1, 2018
Offline
For which version(s) of Excel?
September 9, 2020
Offline
Hi Velouria,
- My version : Microsoft Excel 2016 MSO (16.0.8201.2193) 32 bits.
- + Subscription: Microsoft Office 365 ProPlus
Trusted Members
Moderators
November 1, 2018
Offline
So I guess you don't have functions like FILTER or UNIQUE available?
September 9, 2020
Offline
Indeed, these functions are not available.
July 16, 2010
Offline
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
September 9, 2020
Offline
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
July 16, 2010
Offline
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
1 Guest(s)
