Hi,

I am a Health care researcher with the following problem:

I have a EXCEL spread sheet that has zip codes of various hospitals and the number of beds in each of them. I am interested to find out how many beds there are within say a ten mile radius of any zip code in that list. So for every zip code in the data, I have to (a) find the zip codes within a 10-mile radius and (b) sum the number of beds in each of these zip codes.

Is there an easy way to do this? I have EXCEL Map point (old version on CD) but I cannot seem to automate the process with it.

Thanks a ton!