This is an easy one, I feel like I just do not know the correct formula... but anyway...

I have a long column of names (text) in my spreadsheet, and I want to display the name that appears the most amount of times. I would also like to format the formula where if I filter the information related to each name, the result will change. For example I would like it to look like this:

77041 Bob
77041 Bob
77032 Bob
77032 Jen
77032 Jen

Most Frequent = Bob
Most Frequent if filtered for 77032 = Jen

I'd appreciate the help!