Place | Person |
Maropeng | Jetash |
Maropeng | Jetash |
Maropeng | Jetash |
Zoo | Mark |
Maropeng | Inkly |
Maropeng | Sleops |
Zoo Lake | Mark |
Zoo Lake | Mark |
Zoo Lake | Misty Wash |
Good day all |
I am trying to create a dynamic / dependent data validation. this is what I am trying |
under "Places" I create a unique data validation list that woks perfectly in a table form and an Index formular |
I am struggling to add the "Staff" data validation dependent to the "Places" validation witch is unique |
so if I choose "Maropeng" for example how do I get the "Place" validation to show the unique list for "Place" |
so |
Maropeng and the list shows , Jetash, Inkly and Sleops and not Jetash, Jetash, Jetash, Inkly and Sleops. |
Thank you in advance |
Jetash |