Find Zip Codes Inside A Radius Using Excel.

Asked By A Williams 30 points N/A Posted on - 09/26/2016

In excel, finding the addresses in a circle can be useful to design any direct mail campaign. How to find zip codes inside a radius in an excel sheet?

• Status: Open
• Question Views: 1823
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel

Answered By H. George 0 points N/A #92880

Find Zip Codes Inside A Radius Using Excel.

1) Open an excel sheet.

2) Right-click on any cell and select InsertCDXFindRadius Function.

3) A pop-up window will appear. Fill in the zip code ad radius, and then click OK.

4) A list will appear showing all the zip codes along with the radius.

USING SEARCH BUG

1) Go to www.searchbug.com

2) Go to tools->zip code->by radius.

3) Enter the zip code and the radius you want to find in.

4) Click on OK.

5) A list will pop as shown, giving all the names of city and country with that zip code and within that radius.

About H. George

Questions
31

Answers
48

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 09/26/2016
• Question Category: MS Excel