Forum Discussion
Solved
Have text list of files, need to group like with like within same cell.
This is for a museum database, we have a list of filenames of photographs. Each filename starts with the collection number. We need to group all the filenames that start with the same prefix into a s...
As variant
=LET(names, $A$1:$A$29, GROUPBY(TEXTBEFORE(names, "-"),names,ARRAYTOTEXT,3,0) )
As variant
=LET(names, $A$1:$A$29, GROUPBY(TEXTBEFORE(names, "-"),names,ARRAYTOTEXT,3,0) )
That definately looks like it should suit our purposes, thank you!