Forum Discussion
Solved
Filtering for specific rows and concatenating cells within that row
I have made some headway on this one, but falling short. I need to filter for rows with a specific cell value. Then once found, return a specific cell and concatenate a group of other cells in that...
NotSoFastEddie Perhaps something like this:
=LET( arr, FILTER(MainSheet!$E7:$M15, MainSheet!$A7:$A15="BUNDLE IDENTIFIER"), HSTACK(TAKE(arr,, 1), "["&BYROW(TAKE(arr,, -5), LAMBDA(r, TEXTJOIN(", ",, r)))&"]") )See attached...
NotSoFastEddie Perhaps something like this:
=LET(
arr, FILTER(MainSheet!$E7:$M15, MainSheet!$A7:$A15="BUNDLE IDENTIFIER"),
HSTACK(TAKE(arr,, 1), "["&BYROW(TAKE(arr,, -5), LAMBDA(r, TEXTJOIN(", ",, r)))&"]")
)
See attached...
You are making me cry. I resorted to scanning the list of excel formulas looking for something that peaked my interest. I looked into LAMBDA but just don't know enough EXCEL to break it down. I thank you very much for your time and effort. I thought I was almost there using FILTER function with two criteria "BUNDLE IDENTIFIER" * UNIQUE on the BUNDLE ID and was receiving a #VALUE .