CLICK on an entry in the boxes that follow to see details of the function as implemented in Excel.
(Scroll down for the 40+ functions available in multiple categories)
5 Digit Zip Code Functions....
|List Zip Codes in an Area Code||Lookup Information about a Single Zip Code||Lookup Zips in a State or County|
|Find Zip Codes around other Zip Codes||Distance between Zips||Distance between a Zip Code and an Area Code/Exchange|
|Select Zip Codes by Zip Code Range||Select Zip Codes by City Names||List Zips around an Area Code/Exchange|
|List Area Codes/Exchanges around a Zip Code|
3 Digit Zip Code Functions....
|Find 5 Digit Zips in a 3 Digit Zip||Find 5 Digit Zips around a 3 Digit Zip||Find 3 Digit Zips around a 3 digit Zip|
|Lookup from a City Name||Lookup From Part of a City Name||Lookup Cities in a State or County|
|Statistics by County||Counties in a State||Lookup Zips in a State or County||Lookup Area Codes/Exchanges in a State or County||Lookup Cities in a State or County|
Area Code Functions....
|Area Code Changes by Year||Area Code Changes by State||Complete Area Code List||Information about an Area Code||List Zip Codes in an Area Code|
Area Code Change Details Functions....
|Exchanges within an Area Code Change Details||Exchanges within an Area Code Change Listing|
Area Code/Exchange Functions....
|List Information about an Area Code/Exchange||List Exchanges in an Area Code||List Area Codes possible for an Exchange|
|Distance between Two Area Codes/Exchanges||Distance between a Zip and an Area Code/Exchange||List Zips around an Area Code/Exchange|
|List Area Codes/Exchanges around a Zip Code||List Area Codes/Exchanges around an Area Code/Exchange||Lookup Area Codes / Exchanges in a State or County|
Telephone Number Functions....
|Telephone Number Check against Zip Code|
Batch Processing Functions....
|Batch Process Zips Around Zips||Batch Process Zips/ACX Near an Office||Batch Process ACX or Zips Around ACX or Zips|
|Batch Process Distance Between Zips||Batch Process Zip Around ACX||Batch Process Closest Zips|
|Batch Process Distance between Zips||Batch Process Zips in a State's Counties||Batch Process Area Codes/Exchanges in a State's Counties|
Cell Level Functions....
|Distance Between Zips|
Change History Functions....
|Zip Code Change History||City Detail Change History||Area Code / Exchange Change History|
|Click for General and Ordering Information about JCSExcel|
If you like what you see on these pages,
We have a growing list of available products and options relating to the data displayed by these pages and the logic supporting the calculations. To see what is available, Click here.
We apologize for any inaccuracies.
Click to send us Email, or phone us at cell 952-210-4234.
All information © Jay Computer Services, 1998 through 2017