Display Only Common Lines Across Two Cells in a Row

[grimley2]

A​	B​	C​
Apple Pie Banana Pear Orange Tangerine	Apple Pie Apricot Pear Plum Jam	Apple Pie Pear

Hello, I'm looking for a formula to generate cell C in this example, displaying the common lines across cells A & B.
The data is delimited with line breaks, but is comprised of multiple lines within individual cells, not down a column.
Thank you!

 

[Jeffrey Mahoney]

Please try this formula in cell C1:
=TEXTJOIN(CHAR(10),TRUE,FILTER(TEXTSPLIT(SUBSTITUTE(A1,CHAR(10),","),","),IFERROR(TEXTSPLIT(SUBSTITUTE(A1,CHAR(10),","),",",,TRUE)=TEXTSPLIT(SUBSTITUTE(B1,CHAR(10),","),",",,TRUE),FALSE),""))

 

[grimley2]

I'm finding that only returns the first match.

 

[grimley2]

This was suggested to me on Reddit, I'm wondering if it's also possible to display the output as a vertical list like the input(s):
=TEXTJOIN(CHAR(10),1,IF(ISNUMBER(MATCH(TEXTSPLIT(A1,,CHAR(10)),TEXTSPLIT(B1,,CHAR(10)),0)),TEXTSPLIT(A1,,CHAR(10)),""))

 

[Jeffrey Mahoney]

It worked for me

 

[Fluff]

This was suggested to me on Reddit,

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

If you have posted the question on any other site please supply a link to those site(s)

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Fluff]

I'm wondering if it's also possible to display the output as a vertical list like the input(s):

Have to turned on Wrap Text for that cell?

 

[grimley2]

Wrap text did the trick thank you!

Here is a link to the thread on Reddit:
https://www.reddit.com/r/excel/comments/zs8zul/compare_lists_across_cells/

 

[Fluff]

Glad it's sorted & thanks for letting us know.