Pull out duplicate word

Need a function or Macro that will look through a column on excel, and in Cell B2 write the words or string of characters that is in every single row in column A

I provided an example book that shows the data in column A and the desired outcome in cell B1

Thanks.

If A2 = "red yellow blue", would the answer still be "red yellow" or are you searching for which cell contains words present in all cells?

Searching all cells for unknown commonality would be a bit trickier than searching all cells for a single cell's values.

Sounds like a job for an array or some form of scripting dictionary!

This worked:

Please Login or Register  to view this content.

Oh hey, this works too.

Technically, not all words need catalogued if values in A1 have to exist in all cells. This just checks each word in A1 and finds which ones appear in all of the others.

Please Login or Register  to view this content.

Here's another possibility.

Please Login or Register  to view this content.

Thanks for the rep. points.

Please click the Thread Tools drop down box above your first post and choose solved.