Forum Discussion
Handling an array contining the same element multiple times
One of the things (among quite a few) I find frustrating with the new-generation functions in Excel is their occasional limited scope. Two examples are XLOOKUP() and XMATCH: it took me a while to und...
A revision from my earlier formula:
=BYROW(MAP(rng,LAMBDA(x,IF(ISTEXT(x),x,IF(x=2,INDIRECT(ADDRESS(1,COLUMN(x))),"")))),LAMBDA(row,TEXTJOIN(",",TRUE,row)))
=BYROW(MAP(rng,LAMBDA(x,IF(ISTEXT(x),x,IF(x=2,INDIRECT(ADDRESS(1,COLUMN(x))),"")))),LAMBDA(row,TEXTJOIN(",",TRUE,row)))