协助动态清单 [英] Assistance with Dynamic Lists

问题描述

我正在尝试根据设定的条件创建动态列表.我有一个代理商列表和一个团队代码列表，我希望能够根据条件选择"一个团队代码并提取"该团队的代理商列表.

I'm trying to create a dynamic list based on a set criteria. I have a list of Agents, and a list of Team Codes and I want to be able to "select" a team code and "extract" the list of agents for said team based on the criteria.

(就数据而言)确实没有比这复杂的多了:

It's really not much more complicated (as far as the data is concerned) than this:

Team          Agent
Team1         Him
Team1         Her
Team2         Me
Team2         You

然后我选择"Team1"并在列表中选择他和她"，或者选择"Team2"并在列表中选择我和你".

and I select Team1 and get Him and Her in a list, or Team2 and get Me and You in a list.

推荐答案

感谢帮助人员.

我实际使用的是一个像数组一样起作用的数组公式.

What I actually wound up using was an array formula that worked like a charm.

{=IF(ROWS('KPI DASHBOARD STATS'!K$3:K3)<=$M$2,INDEX(INDIRECT(O$29),SMALL(IF(MKPI_TEAM_CODE=$L$2,ROW(MKPI_TEAM_CODE)-ROW('KPI DASHBOARD STATS'!$K$3)+1),ROWS('KPI DASHBOARD STATS'!K$3:K3))),"")}

ROWS('KPI DASHBOARD STATS'!K$3:K3)<=$M$2
This counts the number of rows (where they are) in respect to the "count" of my agents
INDEX(INDIRECT(O$29),SMALL(IF(MKPI_TEAM_CODE=$L$2,ROW(MKPI_TEAM_CODE)-ROW('KPI DASHBOARD STATS'!$K$3)+1),ROWS('KPI DASHBOARD STATS'!K$3:K3))),"")
This part indexes and matches based on the criteria.

这篇关于协助动态清单的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！