ExcelBanter - How to create automated find of common names in seperate columns?

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How to create automated find of common names in seperate columns? (https://www.excelbanter.com/excel-discussion-misc-queries/237641-how-create-automated-find-common-names-seperate-columns.html)

Exceldummy

How to create automated find of common names in seperate columns?

I'm looking for a way to do an automated find of common surnames in seperate
columns, but in the same row.

All times are GMT +1. The time now is 04:16 PM.