Other Slightly Complex Criteria Ranges

The criteria range shown in Figure 11.12 is based on two different fields. They are joined with an OR. The query finds all records from either the West region or records where the product is XYZ.

Figure 11.12

The criteria range in J1:K3 returns records where either the Region is West or the Product is XYZ.

Joining two criteria with OR might be useful where new California legislation will impact shipments made to California or products sourced at the California XYZ plant.

0 0

Post a comment