Forum

Notifications
Clear all

Two dependent lists without duplicates

9 Posts
3 Users
0 Reactions
86 Views
(@questvba)
Posts: 125
Estimable Member
Topic starter
 

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

 
Posted : 02/09/2021 2:47 am
(@debaser)
Posts: 838
Member Moderator
 

For which version(s) of Excel?

 
Posted : 02/09/2021 5:08 am
(@questvba)
Posts: 125
Estimable Member
Topic starter
 

Hi Velouria,

  • My version : Microsoft Excel 2016 MSO (16.0.8201.2193) 32 bits.
  • + Subscription: Microsoft Office 365 ProPlus
 
Posted : 02/09/2021 7:39 am
(@debaser)
Posts: 838
Member Moderator
 

So I guess you don't have functions like FILTER or UNIQUE available?

 
Posted : 02/09/2021 10:36 am
(@questvba)
Posts: 125
Estimable Member
Topic starter
 

Indeed, these functions are not available.

 
Posted : 02/09/2021 2:45 pm
(@mynda)
Posts: 4762
Member Admin
 

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

 
Posted : 02/09/2021 6:57 pm
(@questvba)
Posts: 125
Estimable Member
Topic starter
 

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

 
Posted : 03/09/2021 1:46 am
(@mynda)
Posts: 4762
Member Admin
 

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

 
Posted : 03/09/2021 2:12 am
(@debaser)
Posts: 838
Member Moderator
 

I sympathise as I'm in exactly the same situation at work!

 
Posted : 03/09/2021 6:13 am
Share: