How do I select the top 10 of something based on distance from a city

[sopink]

Hello,

I need to reduce a large list in an Excel workbook to just the top 10 insurance brokers for a city based on the distance from the city. I need this done for multiple cities.

For example:

City Broker Distance (km)
A Smith 0.5
A Jack 0.7
A Joe 1.0
.
.
.
A Kirk 18.6
B Jackie 0.9
B Joe 1.5

this keeps going. I have the list sorted by City then distance.

The broker could repeat as there are a limited number but the distance of that broker will change depending on how far away the broker is from that city.

Is there a way to do this efficiently?

I tried Top 10 in Pivot Tables but because I need the top 10 brokers for each city it didn't work.

Thanks

[NBVC]

If I understood correctly it can be done with a Pivot table for each city. See attached.