Filter data on multiple criteria
Results 1 to 2 of 2

Thread: Filter data on multiple criteria
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    May 2019
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Filter data on multiple criteria

    I need help filtering on multiple criteria. Consider the sample data below that provides a greatly simplified data set. I need to show all data for the current date and any data from previous dates with a status of "Complete Pending Verification. I am not sure if it will matter, this table will be populated by a macro that will pull data from multiple files and combine them into a single table.

    ID Project Name Status Date Site Number Address City State
    1 Project 1 Complete 6/17/2019 9901 1417 S Hanover St Pottstown PA
    2 Project 1 Complete 6/17/2019 9902 51 Berkley Rd Paulsboro NJ
    3 Project 1 Complete 6/17/2019 9903 51 Berkley Rd Paulsboro NJ
    4 Project 1 Complete 6/17/2019 9904 51 Berkley Rd Paulsboro NJ
    5 Project 1 Complete Pending Verification 6/17/2019 9905 51 Berkley Rd Paulsboro NJ
    6 Project 1 Complete Pending Verification 6/17/2019 9906 51 Berkley Rd Paulsboro NJ
    7 Project 1 Complete Pending Verification 6/17/2019 9907 51 Berkley Rd Paulsboro NJ
    8 Project 1 Complete Pending Verification 6/17/2019 9908 6600 Perkiomen Ave Birdsboro PA
    9 Project 1 Carryover 6/18/2019 9909 3700 W 103rd Street Chicago IL
    10 Project 1 Carryover 6/18/2019 9910 5701 NORTHAMPTON B VIRGINIA BEACH VA
    11 Project 1 Carryover 6/18/2019 9911 2999 EVESHAM RD VOORHEES NJ
    12 Project 1 Carryover 6/18/2019 9912 8800 Walther Blvd Parkville MD
    13 Project 1 Rescehduled 6/18/2019 9913 5048 FERRELL PARKW VIRGINIA BEACH VA
    14 Project 1 Rescehduled 6/18/2019 9914 1702 S. BURNT MILL VOORHEES NJ
    15 Project 1 Rescehduled 6/19/2019 9915 1901 EARL L CORE RD Morgantown WV
    16 Project 1 Rescehduled 6/19/2019 9916 76 Springside Rd Westhampton NJ
    17 Project 1 Rescehduled 6/19/2019 9917 76 Springside Rd Westhampton NJ
    18 Project 1 Rescehduled 6/19/2019 9918 450 Delsea Dr Malaga NJ
    19 Project 1 Cancelled 6/19/2019 9919 450 Delsea Dr Malaga NJ
    20 Project 1 Cancelled 6/19/2019 9920 150 S Main Street Perry MI
    21 Project 1 Cancelled 6/19/2019 9921 2600 Anderson Hwy Powhatan VA
    22 Project2 Complete 6/24/2019 9922 2600 Anderson Hwy Powhatan VA
    23 Project2 Complete 6/24/2019 9923 975 E Little Creek Rd Norfolk VA
    24 Project2 Complete 6/24/2019 9924 975 E Little Creek Rd Norfolk VA
    25 Project2 Complete 6/24/2019 9925 6955 Crain Highway LaPlata MD
    26 Project2 Complete Pending Verification 6/24/2019 9926 6955 Crain Highway LaPlata MD
    27 Project2 Complete Pending Verification 6/24/2019 9927 5311 Madisonville Rd Cincinnati OH
    28 Project2 Complete Pending Verification 6/24/2019 9928 5311 Madisonville Rd Cincinnati OH
    29 Project2 Complete Pending Verification 6/25/2019 9929 805 Leidy Rd Westminster MD
    30 Project2 Carryover 6/26/2019 9930 7540 W. Hillsborough Ave. Tampa FL
    38 Project2 Carryover 6/26/2019 9931 9201 Frankford Avw Phila PA

    I look forward to your suggestions.

  2. #2
    New Member
    Join Date
    May 2019
    Posts
    13
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Filter data on multiple criteria - Solved

    Disregard - I found the solution online

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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