I deal with your exact problem. Here is how I deal with it.
1) I use the drawing tools to draw a circle around the pushpin which I wish to use as the center point. I typically look at a 20 mile radius.
2) I export all the enclosed pushpins with Pushpin Tool (trial version available on this site).
3) I then use a formula I found at the following address to compute distance between the center pushpin and the object pushpin (
http://www.cpearson.com/excel/latlong.htm)
4) I then use a nested IF/THEN function in Excel to break the distances into 5 mile radius increments.
5) Finally, I sort and do a subtotal on the IF/THEN function that defines the 5 mile radius increments.
Hope this helps.