How can I return the most frequently occurring text entry that fits a given
critiera?
E.g.

__A__ __B__
Atlanta John
Atlanta John
Atlanta Mark
Atlanta John
Boston Mark
Boston John
Boston Mark
Boston Mark
Boston Mark

I would like to be able to return IF(A=Atlanta,Mode(B)) = John.

Thanks.