Microsoft Tech Community is in Read Only mode.  Please enjoy browsing our content while we complete our platform upgrade.

Forum Discussion

NotSoFastEddie's avatar
NotSoFastEddie
Brass Contributor
May 07, 2024

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 row.  What I have working is only an attempt at the filter and concatenation but my formula is concatenating all rows with the specific cell value "BUNDLE IDENTIFIER".  I think if I had a unique value , I could reduce the scope.  I know there has to be a better way.

 

 

    • NotSoFastEddie's avatar
      NotSoFastEddie
      Brass Contributor
      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 .

Resources