How to display filtered data?

[BittenApple]

Hello all,
I have 3 dependent dropdowns. They work, that means one is dependent on the other one.

The user selects items from dropdowns, base on whatever is pulled the data has to be displayed.

is there any function that makes the data spills as we select these items?

Please find the attachment.

Regards,
BittenApple

[HansV]

Do you and all users have Microsoft 365?

[BittenApple]

Hello Hans,
Every one has 365 in the company. I am not sure if there would be external users without office 365.

I created dropdown for each list, but when I go to create a name range in name manager, my name shouldn't have spaces. When I put underscore for name ranges, then that makes the name range different than the values I have in the data sheet.

In the table, I have carriar A but for the name manager, I need to give carriar_A. I don't know how bypass this problem.

Regards,
TTi

[HansV]

See your other thread space in the name range.

Formulas that spill data into adjacent cells are only available in Excel in Microsoft 365 (and in Excel Online). So if there is a chance that some users don't have Microsoft 365, you shouldn't rely on spilling.

[BittenApple]

Hans,
What is the formula?
Regards,
Bita

[HansV]

I don't know which formula you mean...

[BittenApple]

Thanks,