=BYROW(A10:A12,LAMBDA(newsource,LET(source,A3:E5,TEXTJOIN(" - ",TRUE,IF(CHOOSEROWS(DROP(source,,1),XMATCH(newsource,TAKE(source,,1)))>0,SEQUENCE(,COLUMNS(source)-1),"")))))
I found which months are full with the formula below. I want to do this topic as a different table but the order is different. How can I do it?
=TEXTJOIN(" - ";TRUE;FILTER((B3:E3>0)*(SEQUENCE(;COUNTA($B$2:$E$2)));(B3:E3>0)*(SEQUENCE(;COUNTA($B$2:$E$2)))>0))
View attachment 87764
=LET(
monthNumber, SEQUENCE(, 4),
months, BYROW(values, LAMBDA(x, TEXTJOIN(" - ", , FILTER(monthNumber, x)))),
XLOOKUP({"b"; "c"; "a"}, header, months)
)