Jul 11 2022 12:50 PM
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
Jul 11 2022 01:23 PM
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"))
Jul 11 2022 02:43 PM
Solution@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
Jul 12 2022 06:28 AM
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" ) ) ) ) ) )
Jul 13 2022 10:04 AM
Jul 13 2022 10:18 AM
@ds100 , you are welcome
Aug 02 2022 08:03 AM
Map function came in handy for something else. Thanks again
Jul 11 2022 02:43 PM
Solution@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