Microsoft Office Tutorials and References
In Depth Information
Exhibit 4.14 Sales example with filter
that contains the database (A1:H23), or we can simply capture the row containing
the field titles (A1:H1). Excel assumes that if the field title row is captured, the
rows containing data that follow directly below represent the records of interest.
Exhibit 4.14 shows the steps involved: (1) I prefer to capture the database including
titles (A1: H23), (2) select the Data ribbon, and (3) select Filter in the Sort and Filter
group. Excel will place a pull-down menu into each title cell and will make available
for selection as many unique items as appear in each column containing data. This
is shown in Exhibit 4.15. For example, if we select the pull-down menu in column
B, Slsprn (salesperson), all the salesperson names will be made available—Bill,
Henry, Harriet, Ahmad, etc. Selecting an individual name, say Bill, will return all
records related to the name Bill and temporarily hide all others that do not pertain.
To return to the entire set of records, simply de-select the Filter by selecting the
Filter again, or select ( All
) in the pull-down menu of the Slsprn field. The former
removes the Filter pull-down menus and exits, and the latter returns all records
without exiting the Filter tool. Thus, the database is never permanently changed,
although some records may be hidden temporarily. Also, we can progressively select
other fields for further filtering of the data. This makes each successive query more
Search JabSto ::

Custom Search