Datasheet

In Figure 1-15, for example, the Boolean expression in cell A14 (>1), checks to

see whether a value is greater than 1, and the Boolean expression in cell B14

(>=5) checks to see whether the value is greater than or equal to 5. Any

record that meets both of these tests gets included by the filtering operation.

Here’s an important point: Any record in the table that meets the criteria in

any one of the criteria rows gets included in the filtered table. Accordingly, if

you want to include records for items that either cost more than $1 apiece or

that totaled at least $5 in shopping expense (after multiplying the quantity

times the unit price), you use two rows — one for each criterion. Figure 1-16

shows how you would create a worksheet that does this.

Running an advanced filter operation

After you set up a table for an advanced filter and the criteria range — what I

did in Figure 1-17 — you’re ready to run the advanced filter operation. To do

so, take these steps:

1. Select the table.

To select the table, drag the mouse from the top-left corner of the list to

the lower-right corner. You can also select an Excel table by selecting the

cell in the top-left corner, holding down the Shift key, pressing the End

key, pressing the right arrow, pressing the End key, and pressing the

Figure 1-16:

A work-

sheet with

items that

meet both

criteria.

Part I: Where’s the Beef?

05_045992 ch01.qxp 1/18/07 5:45 PM Page 28