Forum Discussion
Solved
Dependent Dropdown List With Pivot Table
Hello, I've got a set of data which will be dynamic so I created a pivot table to be able to sort the data and create a dependent drop down list. I need to create a 3 level drop down list. ...
Hi @kheldar
As Riny_van_Eekelen mentioned, using Excel 365 it is possible with FILTER and UNIQUE without using a pivot table.
The attached example is functional from Shift to Name where eg the formula in i9 results in the drop down list that is used in i2.
=UNIQUE(FILTER(Table1[Name];(--(Table1[Shift]=--$G2))*--(Table1[Group]=$H2)))G9 concatenates hour with minutes to make it look like time. TEXT() is not generic functional since h:mm is translated into eg t:mm in swedish Windows.
HOUR(data) & ":" & TEXT(MINUTE(data);"00")--G2 makes Excel treat the string as a number again.
-/-
G8:i9 may be cut and pasted on another sheet.
In deed, here are lots of skilled and experienced people giving helping hands.
Thank you for your feedback 🙂
Thank you for your feedback 🙂
I saw this thread as i'm looking for almost similar scenario. I would like to ask how to do this if the shift header is not a time related, just text but also duplicates. Thank you!