Saturday, May 10, 2014

yogi_From A List Of Names And RoomNumbers Compile A Row By Row List Of Names Associated With Each Unique RoomNumber


                                         Google Spreadsheet   Post  #1632
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   May-10-2014
post by: Miss Brittany (https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/jhYvP0gj84g)
Convert Filter to Array Formula?

I have a working example of what I'm aiming for in cell B:2 of the "arrangements" sheet :

=TRANSPOSE(IFERROR(FILTER(list!A2:A,SEARCH(A2,list!B2:B))))

However, it only returns one row of names, where I would like for it to return all of the results arranged in the exact same way that this code does. Many thanks in advance!
-------------------------------------------------------------------------------------------------------------------------------------