Display most frequent occuring name

Use pivot tables..Count of Bob will show up 3 times (maximum). In a separate cell next to the pivot tables you could using match & index to get highest count

This will enabling filtering data too!