Excel VBA function, retruning a name associated with the max % [closed]

Given an Excel sheet with 2 columns (AgentsNames and AgentRatingScores), How to sum the RatingScores for each agent and return the name of the agent with the maximum % of RatingScore in a cell ?