Dynamic Data Validation List - 2 criteria

[smartbuyer]

hello,

I would like to ask some help on how to create a dynamic validation list with 2 criteria

this formula seem to isolate the Mondays but not sure how to add the Department name as an additional criteria

Please Login or Register  to view this content.

I have attached a sample file with the desired data validation list output.


Thanks in advance!

[José Augusto]

Hi

I use a pivot table to get something similar.

See if the solution works for you.