+ Reply to Thread
Results 1 to 4 of 4

How do I filter my data list from another list of zip codes.

  1. #1
    Registered User
    Join Date
    07-16-2019
    Location
    jaipur
    MS-Off Ver
    2010
    Posts
    3

    How do I filter my data list from another list of zip codes.

    I have a data list with colums- Name, Address, City, Zip codes - not all zipcodes pertain to my service area.

    I have a seperate zipcode list that i want to use for filtering, and I want to see records of only those zipcodes.

    Using Vlookup function gives me single vaules only. For example, i have 9 records from zipcode 91006, when I use vlookup I only get a single a record with that zipcode.


    Please tell me how to filter my data list from another list of zipcodes?

  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,855

    Re: How do I filter my data list from another list of zip codes.

    I'd recommend uploading sample workbook. Without it we can only give you generic answer.

    To upload use "Go Advanced" button, follow "Manage Attachments" hyperlink. It will launch new tab/window for managing uploads.

    If you are unable to upload for one reason or another, try one of the following methods.

    1. Advanced Filter Copy
    2. INDEX/AGGREGATE formula construct (note that you'll need to have formula fill in for enough rows for maximum number of expected record).
    3. Use Pivot Table with Slicer/Filter field to select desired info.

    etc.
    ?Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.?
    ― Robert A. Heinlein

  3. #3
    Registered User
    Join Date
    07-16-2019
    Location
    jaipur
    MS-Off Ver
    2010
    Posts
    3

    Re: How do I filter my data list from another list of zip codes.

    Here is the sample workbook.

    I want to see records that fall in zipcodes mentioned in the row I
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    12-13-2013
    Location
    Calgary,AB,Canada
    MS-Off Ver
    2016,O365
    Posts
    236

    Re: How do I filter my data list from another list of zip codes.

    G2=IFERROR(ROW()*(1^MATCH(E2,I:I,)),"/")

    then you could direct sort all row by column G (all rows with number in column G is your "service area")
    or
    you could also use row# in column G to extract all columns in service area only.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Filter contact list by zip codes from a list
    By rafayhaq in forum Access Tables & Databases
    Replies: 1
    Last Post: 07-17-2019, 02:25 AM
  2. Drop Down List with Filter and the Filter list in one single column
    By wpm7113 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 10-28-2016, 06:38 AM
  3. Replies: 2
    Last Post: 03-16-2014, 10:04 AM
  4. [SOLVED] List of Codes on one sheet, Billing data on another sheet, highlight code if in list
    By children in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-18-2013, 05:03 PM
  5. [SOLVED] Populate list of user defined codes with checked data
    By johnmarkp in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-08-2013, 04:02 PM
  6. Filter Zip Codes from a list codes
    By jaugent27 in forum Excel General
    Replies: 3
    Last Post: 06-11-2013, 02:01 PM
  7. Extract a list of codes from data
    By jp001 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-06-2011, 04:02 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1