Sorting and Ranking by Formula / Function?

Hello.  Here is a summary of my data table to start off: Column A: Employee Name Column B: Location Column C: (e.g. productivity rating)   Now, this is the summary table in a separate worksheet ...