I have a list of agents assigned to team leads. I need to have this list to be able to update as team changes happen month over month. The formula looks to be working except is add one too many name of agents to each of the teams that does not belong. I need help with index Extraction formula pulling 1 too many names (agents) not matching the constant value (team Lead). Here is the formula
=IFERROR(INDEX($A$1:$A$150,SMALL(IF($B$1:$B$150=G$1,ROW($B$2:$B$150)-ROW($G$1)+1),ROWS($G$1:$G1))),"")
what is happening is for each team it pulls one extra name at the bottom of the list that does not belong to that team of agents.
see attached
Bookmarks