Zip codes and Distances

B

brutonparish

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Zip codes and Distances 4
Filter ZIP codes into ranges 6
VLookup Function HELP 7
Zip Code/Service Area help 2
sort by zip code 2
VLOOKUP formula? 12
lining up 2 columns of zip codes 1
What formula should I use? 1

Top