Hello,
I am trying to extract text from multiple cells that exist in a pivot table and return the concatenated text to one single cell in a separate workbook. Below are more details on what I am talking about.
In workbook one, there are data in this format in a pivot table:
Column A) Line Title
Column B) RU Title
Column C) Comment
I would like to have the formula search for a specific set of Line Title and RU Title and return the associated comment. For example, the line title might be "Advertising" the RU Title "Asia" and the Comment "+1.4 million; television". It is possible that there will be multiple rows that flow Advertising-->Asia--> Comment and I would like this formula to return ALL of those comments together in one single cell.
Thanks in advance for your help.
Kyle S.
p.s. I basically want to do a SUMIFS() but for text...
I am trying to extract text from multiple cells that exist in a pivot table and return the concatenated text to one single cell in a separate workbook. Below are more details on what I am talking about.
In workbook one, there are data in this format in a pivot table:
Column A) Line Title
Column B) RU Title
Column C) Comment
I would like to have the formula search for a specific set of Line Title and RU Title and return the associated comment. For example, the line title might be "Advertising" the RU Title "Asia" and the Comment "+1.4 million; television". It is possible that there will be multiple rows that flow Advertising-->Asia--> Comment and I would like this formula to return ALL of those comments together in one single cell.
Thanks in advance for your help.
Kyle S.
p.s. I basically want to do a SUMIFS() but for text...
Last edited: