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.
