In Column A is a list of car makers from Nissan, Ford, Toyota, etc.

In column B is a list of who sold that make so for example Nissan and Fred could appear in multiple rows.

How do I perform a formula that searches column A for Nissan and then returns me what name from Column B appears most along with Nissan.

example
ColumnA ColumnB
Nissan Fred
Nissan Fred
Nissan Fred
Nissan Mark
Nissan Mark
Ford Mark
Ford Mark
Ford Mark
Ford Mark
Ford George
Toyota George
Toyota George
Toyota Fred

I want to search for Nissan and see what name comes up the most matching Nissan from COlumn B