Joining Multiple Criteria with a Logical OR

You may wish to filter records that match one criteria or another. For example, extract customers who purchased either product ABC or product XYZ. This is called a logical OR criteria.

When your criteria should be joined by a logical OR, place the criteria on subsequent rows of the criteria range. For example, the criteria range shown in J1:J3 of Figure 11.10 tells you which customers order product ABC or product XYZ.

Figure 11.10

Place criteria on successive rows to join them with an OR.This criteria range gets customers who ordered either product ABC or XYZ.

0 0

Post a comment