CDX Technologies

April 2023 Newsletter

Account Log-in

In this newsletter we discuss using formula arrays for bulk zip code analysis..

Out latest Blog posting discusses New Microsoft Office Macro (VBA) Warnings

Check Our Blog

Bulk Radius Analysis with Formula Arrays

A common question we receive concerns creating bulk radius reports with just formulas. Many users also want to only retrieve zip codes alone and not include the radius distance in a separate column.  We’ve previously written blogs describing similar operations including "Dynamic Formulas Radius Analysis" and “Getting Radius Information for a List of Zip Codes”. The technique described below combines these methods to produce single columns of zip code radius reports for one or more central zip codes.

We’ve created an example spreadsheet to demonstrate this concept which can be downloaded here. This spreadsheet will work with the “Lite” version of CDXZipStream or better versions which include the radius function. The picture below shows the report included on the first tab of the spreadsheet.

Columns B, C, and D contain CDXRadius formulas which were entered manually as formula arrays.  To find out more about entering formula arrays please see the following blog article. Rather than 2 columns, only one column was selected as an input range so that only zip codes are returned. The length of each column is 2500 rows which should accommodate most radius reports.  The formulas are dynamic so that when the central zip codes are changed in row 1 or the radius miles is updated in A4 the reports will update correspondingly. If you need to add additional radius reports to the bulk report simply copy the columns B,C or D to adjacent columns. 


This is just one of the very flexible methods of creating radius reports with CDXZipStream.  All you need to do is choose the one which best meets your analysis needs.

Latest Data Updates

U.S. and Canadian data feeds of CDXZipStream were updated as of April 24. If you would like to update your database to reflect these changes, select the "Account" option on the CDXZipStream menu in Excel and click on "Check for Available Database Updates". You can then update each database as required.


CDXZipStream updates are a part of the one-year software maintenance subscription included with your purchase. If you would like to extend your subscription, please sign in to the CDX Technologies website and from the account area for CDXZipStream, select "Buy Data Update".  The maintenance agreement also includes access to the latest version of CDXZipStream.


As always, we hope you find the information here helpful for you and your organization. Prior issues of the newsletter can be found at the following link. You can contact us with your feedback and suggestions by replying to this email.

Hughes Financial Services Inc.
2 West Hanover Avenue,
Suite 212, Randolph, NJ 07869
Support: (973) 895-5542
E-mail CDX
Facebook  Twitter  Linkedin  Youtube