Mar 15 2019 08:44 AM
Trying to create a sub-list from a master list - currently working on two formulas:
=INDEX('Client List'!B:B,MATCH("Chris",'Client List'!C:C,0)) This formula will pull the first cell that matches the criteria, but will not populate the rest
=IFERROR(INDEX('Client List'!B:B,SMALL(IF('Client List'![AT Member 1]="Lindy",ROW('Client List'!)-1),ROW(1:1)),2),"") this formula will not work
Mar 15 2019 08:31 PM
Mar 18 2019 05:56 AM
@Twifoo Thanks for your help! However, i'm still struggling to get it to work. please see test file.
Mar 18 2019 10:23 PM
Mar 19 2019 05:18 AM
@Twifoo See attached, the goal is to have the proper clients under the proper AT Member Names without having to manually do it on the "Main View" sheet
Mar 22 2019 02:22 PM
Solution@zjohnson , that could be like
=IFERROR( INDEX(Table8[Client Name], AGGREGATE(15,6,1/ISNUMBER(SEARCH(Table8[AT Member 1],$A$1))/ ISNUMBER(SEARCH(Table8[AT Member 2],$A$1))/ ISNUMBER(SEARCH(Table8[AT Member 3],$A$1))* (ROW(Table8[AT Member 1])-ROW(Table8[[#Headers],[AT Member 1]])), ROW()-ROW($A$1)) ),"")
for the first section. Not sure what is the logic of the Master List, perhaps formula could be more flexible if know how you build sections.
Mar 22 2019 02:22 PM
Solution@zjohnson , that could be like
=IFERROR( INDEX(Table8[Client Name], AGGREGATE(15,6,1/ISNUMBER(SEARCH(Table8[AT Member 1],$A$1))/ ISNUMBER(SEARCH(Table8[AT Member 2],$A$1))/ ISNUMBER(SEARCH(Table8[AT Member 3],$A$1))* (ROW(Table8[AT Member 1])-ROW(Table8[[#Headers],[AT Member 1]])), ROW()-ROW($A$1)) ),"")
for the first section. Not sure what is the logic of the Master List, perhaps formula could be more flexible if know how you build sections.