ExcelBanter - Most common word

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

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Most common word (https://www.excelbanter.com/excel-worksheet-functions/270422-most-common-word.html)

Randy Mis

Most common word

I am trying to write a formula which will return the most common word (1) in a column for a name in a different column. Example below

A B
Rich Home
Mike Away
Dave Away
Mike Away
Dave Home
Rich Home
Mike Home
Rich Away
Dave Home

I would like the formula to return the following
Rich Home
Mike Away
Dave Home

All times are GMT +1. The time now is 02:50 PM.