zip codes

  1. V

    Excel Calculate Miles from Zip Code to Zip Code

    I am aware that there are other similar questions like this on here, but they seem to be pieced together, and I cannot seem to find a single answer that can be easily deployed. I previously used G_Distance function to calculate miles between a matrix of zip codes, and it worked flawlessly. I now...
  2. R

    Vlookup between 2 zip codes

    I need help here. I have tried to find an answer but nothing. My problem is that I got lot of Zip Codes that connect to a spesific sales Rep. A4 3000 B4 3069 C4 Person 1 A5 3070 B5 3299 C5 Person 2 A6 3300 B6 3599 C6 Person 3 F4 is the place I put the Zip code I want to find a match for...
  3. A

    Urgent - Function needed to done this

    Hi, I have problem Please look at the picture below: In this picture you can each url ending with pagenum=1 There are 29670 rows in excel sheet and all ending with pagenum=1 And also you can see the zip code which is "Ab10" for all 29670 rows. WHAT I AM LOOKING FOR A FUNCTION THAT WILL...
  4. G

    Handling duplicate zips: Combining non-numeric columns into one column, one row.

    Is there a function in Excel that allows you to combine non-numeric columns as a list? For example, 91401 is a zip shared by three cities: Van Nuys, Sherman Oaks and Valley Glen. The data is in a workbook as three rows (each with 91401 as the first column, and cities listed individually...
  5. B

    Trouble with XL2007 Advanced Filter on Many Zip Codes

    Hello, I have followed a tutorial located at: http://www.contextures.com/xladvfilter02.html#TopFive I have Excel 2007 and Win7 What I'm attempting to do is is take sheet1 with 100's of rows of data and about 20 different columns where most rows contain a zip code. I would like to use an...
  6. T

    VLOOKUP problem with zip codes

    VLOOKUP returns incorrect results when comparing zip codes across worksheets. I think the problem could be caused by 2 things: 1. There are duplicate rows in the lookup_value range because each represents an individual and needs to remain a duplicate to show whether there are multiple...
  7. T

    Parsing names and Zip code questions

    I do a lot of spreadsheets where the original may have a set up like this Column A: James Doe Jr Jonathan Doe Jr I need it set up with the first name in the first column and the last name and Jr put into the second column. I have tried text to columns but it puts each part of the name as...

Some videos you may like

This Week's Hot Topics

  • Problem with Radio Button's format control
    I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
  • Last Display on userform to a Listbox
    [CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
  • Rename and move files to a new location
    Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
  • Help with True/False Formula
    Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
  • Clear extra characters from a provided range of cells
    Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
  • Help with Current and highest streaks
    Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...
Top