Forum Discussion
Solved
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
ds100 , you are welcome
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" ) ) ) ) ) )Map function came in handy for something else. Thanks again
Since G3# includes all values of "Symbol" a filter on G3# would include all rows - making the filter obsolete.
=TEXTJOIN(", ",,TEXT(UNIQUE(Table2[Date]),"m/d"))
