zipcode

my issue is getting the default zip code of 99999 answers when the extracted is not a number. I tried isnumber, but it kept rejecting with too many arguments message

I'm trying to find a way to calculate the distance between original zipcode in Column A and destination zipcode in Column B. I've been following other threads that appear to have solved this, however it appears to work on a Windows machine and not a mac. I am unable to change the reference to...

MS Excel 2007. In a large data base of addresses, Column G contains area name and Column J contains 6 digit zipcode. Column G and J are formatted to contain input in "Text". Example : G569: TNagar and J569: 600017. (Zipcode for TNagar is 600017). My requirement: This area name viz...

MS Excel 2007. I have an address data base in which Column J contains Zipcode in 6 digits. I have this Column J formatted under category "Text". For convenience I have entered only last 3 digits, for example 096 in J2. My requirement: A formula for Column J. J2 displays 096. I want this to...

I am attempting to pull a city's "county" from a table by using the zipcode. The formula works, but when attempting to copy the formula into the other cells. It still pulls the original zipcode from the first cell that was entered. I have dragged the formula using the "+" and used control +...

Hello, I have a data set I am working with where I have a long list of zipcodes. I need to count for each individual zipcode, how many entries there are. Here is a picture of my spreadsheet: https://imgur.com/7mEewe5 I am having trouble attaching excel sheet to this post, so here is a dropbox...

Sheet 1 - Summary page with County names in 10 columns Sheet 2 - All sales for out company - 3 columns - ZipCode, Total Items sold to that zip code, Dollar Value (Columns A-C) Sheet 3 - List of Each NH County and Zip Codes - 10 columns with each row containing the zip ode for that column...

I have a userform that has a txtZip, Listbox1, & ComboBox1, cmdGetCity Short Story: I want to search for the Zipcode (txtZip) and State (ComboBox1) columns - and if they match the row of data, display the name(s) of the Cit(y)(ies) of that row (Column D) in Listbox1. Long Story: I want a...

I have a userform that has a txtZip, Listbox1, & ComboBox1, cmdGetCity I want a function that whenever cmdGetCity is clicked, it will search the B2:B81832 range for a zipcode that matches txtZip (entered by user) and, also, search E2:E81832 for data that the users selects in the Combobox 1...

Hi there, I have two sets of data that I need to show if there has been an increase or decrease in over a 2 year period so at present have something that looks like this: <TBODY> Year 1 Year 2 Postcode Number Postcode Number SY23 7 2875 SY66 2 2890 ST65 8 2700 SY23 7 2611 SY66 2...

I know this has been asked before, but threads like this one don't answer my question because I ONLY WANT ZIP CODES IN KENTUCKY. I wish to be able to type in a ZIP CODE into column "B", and have it automatically fill-in the City in column "A". Since the state is always Kentucky, that whole...