Formula to report most commonly entered location query

Hi, I am relatively new to larger formulas in excel and I would greatly appreciate any advice in resolving a formula issue I have.  I have a spreadsheet spanning line 11 to line 400, which will refle...