How to Filter dynamic array with table field-to-dynamic array criteria?

Is there a way - with the Filter function or an alternative - to replicate below function but allowing for $G3# to replace $G3? FILTER(Table2[Date],(Table2[Symbol]=$G3) Thanks

Book3.xlsx12 KB

Formulas and Functions

mtarler
Jul 11, 2022
ds100 alternatively i think you want something like this:
=BYROW(G3#,LAMBDA(r,TEXTJOIN(", ",,TEXT(UNIQUE(FILTER(Table2[Date],(Table2[Symbol]=r),"")),"m/d"))))
using BYROW lets you perform the operation on each row of the G3# spill

SergeiBaklan

MVP

Jul 12, 2022

ds100

Practically the same

=LET(
  u, UNIQUE(Table2[Symbol]),
  IF( {1,0}, u,
      MAP( u, LAMBDA(v, TEXTJOIN(",", 1, TEXT( FILTER(Table2[Date], Table2[Symbol] = v), "m/d" ) ) ) ) ) )

Book3 (1).xlsx12 KB