I need some assistance with a formula in calculating the best performer of a certain category. I work in real estate sales, and essentially I want to be able to find the highest performer of a given area (zip code). So, in short, my data set will have each closing recorded individually to where the agent’s name, then the sales price, commission, then the zip code in which the closing took place.
I want Excel to reference a list of agents in the database, then find the agent who has produced the most closings (highest volume) per zip code. I will need to replicate this for about 55 zip codes. I cannot figure out if it is a large, index, match, mode or if formula.