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