zipcodes

  1. L

    Excel VLookup Results

    I have a spreadsheet with 13 columns and 900 rows (column 1 is zipcodes). I am trying to complete a vlookup that will look at the zip codes in row 14 (I added). Once I receive the matching zipcodes, I need to show the entire rows (Col 1 - Col 13) that has the matching zipcodes. Is vlookup...
  2. A

    Reordering data from several sheets into one

    I have a workbook consisting of 58 sheets. I want the data from the other 57 sheets combined into one table in the 58th sheet. The data-sheets are all identical, they look like this: <tbody> Some heading 5 min 10min 15min 20min 30min 60min 0001 2342 4343 3222 3431 3432 0002 3433 4444...
  3. L

    Summing number of entries for many different entries

    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...
  4. R

    Number Data Does Not Copy Correctly

    I have my data on Google Sheets, and I need it on MS Excel. Here is what I have tried. Copy and paste (multiple formats like number, plain text, HTML). I also copied and pasted it into an email and onto notepad. I also directly downloaded the file from Google Docs as an XLSX format, and that...
  5. D

    Zip Code entry

    I have an input form which contains Name, Address, City, State, Zipcode. Is it possible when the user types in a Zipcode to automatically populate the City and State? Where can I get a list of ZipCodes? My thinking is that I will have a list of zipcodes in one column and associate the City...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top