英文:
Question regarding multiple dependent drop down lists
问题
我目前正在学习有关依赖下拉列表的内容,这对我来说是一个足够简单的概念,我可以理解。
我想知道的是是否可以创建两个或更多与同一单元格有关的依赖列表,因为我不太明白是否可能,这是因为如何创建单个依赖下拉列表。
例如,在下面的图像中,我想创建这样一种情况:如果我在Team单元格中选择TeamA或TeamB,那么只有与该团队关联的球员会显示在Offense和Defense单元格中。
这可能是一个足够简单的问题,但我找不到任何相关信息,所以我感谢您能提供的任何帮助。
英文:
I am currently learning about dependent drop down lists, which is a simple enough concept for me to understand.
What I wanted to know is if it's possible to create two or more lists that are dependent on the same cell, as I don't quite understand if it's possible due to how a singular dependent drop down list is created.
For example, in the image below I wanted to create a situation where if I choose TeamA or TeamB in the Team cell, the only players associatred with that team would show up in the cells Offense and Defense.
This might be a simple enough question but I couldn't find anything on this, so I appreciate any help you can give me.
答案1
得分: 2
使用辅助列(稍后可以隐藏)来创建动态列表:
=FILTER(B4:C6, B3:C3=B8)
参考数据验证列表源中的数组:
结果:
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论