Finding the most common value in a filtered range of cells

Hi all - been banging my head against my desk all day, trying to find what I thought would be a pretty simple solution to my problem.

I have a list of 20,000 recurring names in a column which has been filtered down to around 200 rows by certain criteria in other columns. I now want to know which name appears most often in the filtered list.

Is there an easy way to do this? A VBA solution would be ideal, though if there's a formula which can do the job I'm happy to hear it.

Thanks in advance!