Doghouse308
New Member
- Joined
- May 28, 2019
- Messages
- 13
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.
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I look forward to your suggestions.
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 |
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
I look forward to your suggestions.