Spreadsheet: 879874d1727451196-filtering-data-using-mulitple-criteria-with-and-and-or-functions-test-dynamic-filtering
Sheet: Dynamic Filtering

 | Sales Comps |  |  |  |  |  | Results:
 |  |  |  |  |  |  |  |  |  |  |  |  | Instrument Date
 |  | Building Type |  |  |  |  | Area |  |  |  |  |  | From
 |  |  |  |  |  |  |  |  |  |  |  |  | To
 |  |  |  |  |  |  |  |  | MIN | MAX
 |  | City |  |  |  |  | Square Feet |  |  |  |  |  | File Date
 |  | Zoning |  |  |  |  | $/Square Foot |  |  |  |  |  | From
 |  | Tax ID |  |  |  |  | Sales Price |  |  |  |  |  | To
 |  | Address |  |  |  |  | Acres
 |  | Grantee |  |  |  |  |  |  |  |  |  |  |  | Sorting
 |  | Grantor |  |  |  |  |  |  |  |  |  |  |  | Area |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data Size
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Descending |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sorting ID
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Matched |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Filtered
 | Tax ID | Address | City | Area | Square Feet | $/Square Foot | Sales Price | Zoning | Instrument Date | Grantee | Grantor | Building Type | File Date | Acres |  |  | Tax ID | Area | Inst To | Inst From | File From | File To | Sqft Min | [NAME] | Building Type | $/SqFt Min | $SqFt Max | Acres Min | [NAME] | Sales $ Min | Sales $ [NAME] | Area | City | Zoning | Address | Grantor | Grantee | Tax ID | City | Area
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 46985 | Custer | Southern Hills
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 12584 | Rapid City | Black Gap
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 85425 | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 54593 | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 25545 | Rapid City | City Center
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 55864 | Rapid City | City Center
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 32156 | Rapid City | City Center
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 69841 | Rapid City | City Center
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 48941 | [NAME] | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 89613 | Rapid City | City Center
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 45621 | Rapid City | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 84896 | Rapid City | City Center
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 65484 | Rapid City | SE Rapid
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 15684 | [NAME] | [NAME]