Select Parent Column and that filters out the ParentEntity Column

Hi, I'm trying to give a selection column for range of activities where multiple parententity can be selected however so far I'm only able to filter based on the parententity column as seen below:

SampleI.PNG

The goal is to have the first filter as ParentColumn and then that would then lead to further filtering into details

Any help would be much appreciated

TahnkyouSampleWk.xlsx

If I understand correctly, maybe you could do this:

somewhere in the file (maybe another sheet (hidden), create a list of the unique parents (and sort), like this:

=SORT(UNIQUE(E4:E57),,1)
This represents the first drop down(under data validation, select "List" and reference the spilled list (i.e., if you put the formula in cell P3, in Data Validation under List, enter $P$3#

Then another formula, say in Q3, enter:
=SORT(FILTER(D4:D85,E4:E85=M4),,1)

This represents the 2nd drop-down. Under Data Validation, select "list" and under Source, enter $Q$3#

Thankyou for your response, I understand it does only for one cell - how do I drag to the rest of the cells?

Also following your advise and how you have shown on the sample workbook - I'm still getting 'Spill' for the ParentEntity Column?

I understand it does only for one cell - how do I drag to the rest of the cells?

What do you mean it does only for one cell?

I'm still getting 'Spill' for the ParentEntity Column?

Make sure that every row beneath the lists are empty.

Look at my attachment and you should see how it's working.

That's an invalid attachment. Please follow instructions (yellow banner at top of page) to attach correctly.

for the next row when I select; it still gives option of the above row

Sorry, I don't know what you mean here.

also is it possible to have multiple selection (of the parententity column) based on the parent column?

If I understand, mine does.

Please open my attachment and select cell M4. From the drop-down select "Holden Colorado". The select cell N4, and click on the drop-down icon and you'll see all the ParentEntities that go with that.

I do I do, it does work... but I can select one out of multiple, what I meant was - is it possible to have 2 instead of 1 separated by comma?

and I followed your sample workflow - it works perfectly for the first cell

Sample2.PNG

I dont know if the snapshot got attached or notSample2.PNG

If I understand correctly, you're wanting to have these drop-downs on several cells, working independently. If that's the case, using this methodology, you'd have to have the second formula (the one I put in P3) repeated for each cell you wanted it for. So for instance, in my attachment, if you wanted the same drop-down selection in M5 that's in M4, you would copy that down, but for selection in N5 based off what you selected in M5, you'd have to create another list like what is in cell Q4 based on your selection in M5. Does that make sense?