CDXZipList Function
Previous  Top  Next


For a general overview of how to insert data and functions into your worksheet, please refer to the topic Inserting Data and Functions.

CDXZipList is a right-click function available in all versions of CDXZipStreamTM. It returns a list of ZIP Codes located within the given area. It can be employed as a right-click function as well as input directly into your worksheet as a custom function formula. (Please also refer to the help section on custom functions.)

This function will work with Canadian postal codes, if you have purchased the Canadian data option.

Please also refer to the Youtube video Zip Code List in Microsoft Excel
for a demonstration of the CDXZipList function.

Once you have selected the CDXZipList right-click function, the following input box should appear:

clip0392

Inputs are:

State - The specified state for the ZIP Codes

County - The specified county for the ZIP Codes (optional)

City - The specified city for the ZIP Codes (optional)

Maximum Rows - The number of rows that will contain the returned ZIP Codes

Result Output - Specify Array Formula or a Single String

Only Show ZIP Codes - If this box is checked then city, county, and state data are omitted

With the following inputs for Cherry Hill in Camden County, New Jersey:

clip0393

The result is a list of ZIP Codes (starting at the right-clicked cell in the worksheet) located within the specified area. Each ZIP Code is listed along with its city name, state, and county. Since the maximun number of rows is 10, and only three ZIP Codes meet the criteria of being within the specified town, the remaining seven rows do not contain any data.

clip0394


If a string output is selected, the same data is returned in a single string within the right-clicked cell, with data groups (ZIP Code, city name, county, and state) separated by a "|" :

clip0395


The CDXZiplist function can also be directly input as a custom function formula in the following generalized form:

=CDXZiplist(State, County, City, Zip code only, Result Output)

For the example immediately above, the custom function formula would be:

=CDXZipList("New Jersey", "Camden", "Cherry Hill", 0, 1)

The Result Output is specified as 1, indicating that the data will be returned in a single string.

If the Result Output value is omitted, the Data will be returned to an array within a range of cells. For this case use the following procedure:

Enter the custom function formula in the desired cell:

clip0398

Select this cell, then drag the cursor over the range of cells which will contain the returned array:

clip0399

Click on the formula bar (which should contain the custom function formula), and depress the keys CTRL-SHIFT-ENTER simultaneously. The returned array will appear in the selected range:

clip0397

There is a new set of brackets automatically inserted around the formulas in each selected cell, which Excel uses to indicate this is a member of an array. You may not delete or move just part of the array - the entire array must be deleted or moved, if desired.